IF Formula: IF no date then blank, if date then specific format [Resolved]

[Matthew_Dewey]

Trying to put together a formula that will return a blank result or a date in a specific format and timezone.

This works:
DATETIME_FORMAT(SET_TIMEZONE({Broadcast Date/Time}, ‘Australia/Sydney’), ‘DD/MM/YYYY HH:mm’)

And so does this:
IF({Broadcast Date/Time} = BLANK(), “”,{Broadcast Date/Time})

But not this:
IF({Broadcast Date/Time} = BLANK(), “”, DATETIME_FORMAT(SET_TIMEZONE({Broadcast Date/Time}, ‘Australia/Sydney’), 'DD/MM/YYYY HH:mm’))

I’m missing something here, hopefully obvious. Really not sure what it is.

[Tuur]

Matthew_Dewey:

IF({Broadcast Date/Time} = BLANK(), “”,{Broadcast Date/Time})

How can you be sure this works? :winking_face:

Blank() can be tricky. Does the following work?

IF({Broadcast Date/Time} = BLANK(), “BlankTest”,{Broadcast Date/Time})

[Matthew_Dewey]

Thanks @Tuur, I can confirm that your “BlankTest” formula does work. I just need to get the format of the date working.

[Matthew_Dewey]

Ok, discovery. It appears than when I copied in the formula, it carried the following characters in italic: ’ and ". When I replaced these characters unitalicized, all was fixed and the formula worked.

[Tuur]

:thumbs_up:

8.7.6.5.4.3.2.1

[W_Vann_Hall]

Works perfectly well on my system…