Interesting behavior of IF

[#1]

if I write in my loading script:

if(1=1,  "MyDateTimeField")

as _wojzehDateTime,

then I get:

if I add the second argument:

if(1=1,  "MyDateTimeField", null())

as _wojzehDateTime,

or

if(1=1,  "MyDateTimeField",0)

as _wojzehDateTime,

or

if(1=1,  "MyDateTimeField", '')

as _wojzehDateTime,

then I get:

[Nicole-Smith · Accepted solution]

If you want them all formatted as Date/Time, you should use:

if(1=1,  timestamp("MyDateTimeField")) as _wojzehDateTime,

if(1=1,  timestamp("MyDateTimeField"), null()) as _wojzehDateTime,

if(1=1,  timestamp("MyDateTimeField"),0) as _wojzehDateTime,

if(1=1,  timestamp("MyDateTimeField"), '') as _wojzehDateTime,

[#3]

Thank you Nicole!

Looks like the second argument does not define the final result formatting but the first does.