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


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.


How can you be sure this works? :wink:

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

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


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


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.




Works perfectly well on my system…