Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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,
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,
Thank you Nicole!
Looks like the second argument does not define the final result formatting but the first does.