Skip to main content

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? :winking_face:



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



IF({Broadcast Date/Time} = BLANK(), “BlankTest”,{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})


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.

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…

Reply


Terms & Conditions