Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Add custom text after formula

Topic Labels: Formulas
2549 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaib_Khan
4 - Data Explorer
4 - Data Explorer

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 1

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