how to assign a string value to a date field

[former_member611722]

Hi everyone,
I wrote the following formula:
Basically, I want to say if the variable equals to null or that particular value, then assign the "waiting" to it otherwise show me the actual value. But, it seems it doe not work and I still see '12/30/1999' as the value. Any help on this, please

=If IsNull( [Task Closed Date Time]) Or   FormatDate([Task Closed Date Time];"mm/dd/yy") ="12/30/99"
Then "Wating" Else [Task Closed Date Time]

[amitrathi239 · Accepted solution]

you need to use the month is CAPS in your variable.

=If IsNull( [Task Closed Date Time]) Or FormatDate([Task Closed Date Time];"MM/dd/yy") ="12/30/99" Then "Wating" Else [Task Closed Date Time]

[former_member611722 · Accepted solution]

amit.kumar71 Thank you!