Despite the error, the date is converted correctly

Question

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!

Date Conversion.yxmd

ChrisTX · Accepted Answer

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