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