Hi,
I have this table which contains 2 datetime fields called Startdate & enddate
Startdate cannot contain NULL
Enddate can because it can be a single day event or a period.
If enddate is not null it must be later than startdate
i created this checkconstraint
enddate > startdate
But i also fires when enddate = NULL
Someone knows howto do this?
Cheers Wimenddate > startdate
OR
enddate IS NULL|||Thanx for your reply.
But enddate could be NULL when NOTNULL it should be later then Startdate|||Your point being? :)|||Sorry my bad, calendar control gives me 1-1-1980 instead of NUll
Thanx for ur help!!
CHeers Wimsql
No comments:
Post a Comment