A date-time is required here error 1

[JBourne77]

I am stumped on my formula and the error returned.

A date-time is required here.

Highlights the '1800-01-01 00:00:00.000'

IF {Data.ApptDte} = '1800-01-01 00:00:00.000' then ' ' 
ELSE {Data.ApptDte}

 

[lbass]

Try:

IF {Data.ApptDte} = datetime(1800,1,1,0,0,0) then
datetime(0,0,0,0,0,0) ELSE
{Data.ApptDte}

This would return a blank field--is that your goal? The error message is telling you that ApptDte is a datetime and therefore must be compared to a datetime, not a string.

-LB

 

[JBourne77]

Great explanation and yes, I wanted a blank. You made my day, thanks!!