On Fri, 4 Jan 2019, Andreas Kretschmer wrote:

no, you can use NULL, for instance. You don't need an explicit value.
But maybe you want to set the start_date to NOT NULL.

Andreas,

  Yes, I added NOT NULL to the start_date column.

2. If so, please suggest a value for it.

other solution for such 2 fields: you can use DATERANGE, only one field.

  Only if all projects have a known end_date; some don't.

Thanks,

Rich

Reply via email to