Skip to main content

Add custom text after formula

  • January 10, 2022
  • 1 reply
  • 77 views

I’m using the following formula to show date and time for “Facebook event_time field”…

DATETIME_FORMAT({Date},‘YYYY-MM-DDTH:mm:ss’)

I want to add a letter “Z” to the end of the field… so at the moment its returing the event_time as:

2022-01-10T13:02:00

I want it to look like:

2022-01-10T13:02:00Z

1 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • January 10, 2022

Just add
& "Z"
to the end of your formula.