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


#1

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.


#2

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})


#3

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


#4

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.


#5

:+1:

8.7.6.5.4.3.2.1


#6

Works perfectly well on my system…