I have a report where I am reviewing aging of complaints. Aging is based off the {AWARE_DATE} unless the {PRODUCT_RETURN_DATE} <> 01/01/1900 (default).

I have:

IF {PRODUCT_RETURN_DATE} <> 01/01/1900
THEN
Currentdate - {PRODUCT_RETURN_DATE} >=57
ELSE
Currentdate - {AWARE_DATE} >=57)


But when trying to save this in the Record Selection Formula I get an error stating "A date-time is required here."

I have tried 01/01/00, 01/01/00 00:00:00 with no luck. I also tried putting double quotes.

If this format incorrect for the date to be recognized as 01/01/1900?

Thanks!