bad date-time format string error

[susiesunshine]

This formula is giving me a "bad date-time format string" when I run the report, but shows no errors when checking the formula:

if isnull({HDCAllCases.Closed Date}) then
CurrentDateTime else
datetimevalue({HDCAllCases.Closed Date})

Any ideas?

 

[synapsevampire]

Post what's in:

{HDCAllCases.Closed Date}

-k

 

[synapsevampire]

Yanno, might be something simple, try:

if isnull({HDCAllCases.Closed Date})
or
trim({HDCAllCases.Closed Date}) = "" then
CurrentDateTime
else
datetimevalue({HDCAllCases.Closed Date})

-k

 

[susiesunshine]

Thank you very much, it worked!