Despite the error, the date is converted correctly

[Gromah]

Hi,

I need a little help. Can someone point me to the error in Formula Tool that causes the following message?

Despite the error, the date appears to be converted correctly.

Thanks!

[ChrisTX · Accepted solution]

I think the error comes from the BOOL part of your IIF function

I only use IIF for very simple expressions

Try this:

IF Contains([CPUDTE], "-")
THEN DateTimeParse(tostring([CPUDTE]),"%Y-%m-%d")
ELSE DateTimeParse(tostring([CPUDTE]),'%Y%m%d')
ENDIF

Chris