Date field

[AlreadyLost]

Anyone know the swl syntax for check a null date field.. I have a begin date that have data and I have an end date that is blank.. What is the syntax to check for the end date field ?

 

[LarryJones]

If by SWL you mean SQL then:
a) This is a SQL question, not a Crystal one
b) This syntax can be DBMS dependant, what brand are you using?

 

[h0h0h0]

if you have the syntax for the begin date then apply it to the end date.

WHEN enddate is NULL then '01/01/1980' ELSE enddate END as EndDateFormatted