Help

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

Topic Labels: Dates & Timezones
4271 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthew_Dewey
6 - Interface Innovator
6 - Interface Innovator

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.

5 Replies 5
Tuur
10 - Mercury
10 - Mercury

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

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

Matthew_Dewey
6 - Interface Innovator
6 - Interface Innovator

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.

:thumbs_up:

8.7.6.5.4.3.2.1

Works perfectly well on my system…