Functions
TZTEXT
Human-friendly local string; optional strftime format
Try it
When to use it
When should I use TZTEXT instead of TZSTRING?
Use TZTEXT when the output is for human readers — dashboards, reports, or UI labels — where a readable format matters more than machine parseability. Use TZSTRING when the value must be parsed by another function or system.
What happens if I omit the format argument in TZTEXT?
TZTEXT returns a readable default string such as "2026-07-14 09:00:00" in the local timezone of the zoned value, which is suitable for most display purposes.
Can I use TZTEXT to show the day name and month name in a report?
Yes. Pass a strftime format like "%A, %B %d at %H:%M" to produce output such as "Tuesday, July 14 at 09:00", which is ideal for scheduled-event labels and summaries.
Use cases
Format a shift start time for a staff schedule label
Show a sales call time in the rep's local timezone
Used in
operations · hr · sales
Syntax
TZTEXT(zoned,[format])