Date formula issue

[Extrmdressage]

I want to use a formula like this to get {ELeaveofAbs.ulaDateEnd} = null, but I keep getting the error 'a date is required here'. Can anyone offer advice on how to get this formula to work?


if{ELeaveofAbs.ulaDateBeg} <= CurrentDate and {ELeaveofAbs.ulaDateEnd} >= 0/0/0

then 1

else 0

 

[Turkbear]

Hi,
You need to make the NULL test first and try with the IsNull function:

if
( NOT IsNull({ELeaveofAbs.ulaDateEnd})  )
and
({ELeaveofAbs.ulaDateBeg} <=  CurrentDate )

then 1

else 0

If the IsNull function does not work with your data try

 If NOT ({ELeaveofAbs.ulaDateEnd}) = Date(0,0,0) )
and

({ELeaveofAbs.ulaDateBeg} <=  CurrentDate )

then 1

else 0

To Paraphrase:"The Help you get is proportional to the Help you give.."