> For the complete documentation index, see [llms.txt](https://helpdocs.conducttr.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpdocs.conducttr.com/feature-documentation/designing-and-running/smartwords/functions/datetime-formatting.md). # DATETIME formatting DATETIME(timestamp, format, output timezone) is a Conducttr function used to make dates and times look attractive. * timestamp = input; required, uses the format “yyyy-mm-dd hh:mm:ss” * format = output format, e.g. ‘HH:mm:ss’ (see details) * output timezone = timezone for output; optional, defaults to project’s time zone (currently defaults to project owner’s time zone) ## Formats Below are the date-time formatting specifications.


Format	Description
W	number of the week in the year (Monday is the first day of the week) with leading zero, 00-53
w	number of the week in the year (Sunday is the first day of the week) with leading zero, 00-53
yy or YY	2-digit year, e.g. 16
yyyy or YYYY	4-digit year, e.g. 2016
M	number of the month without leading zero, e.g. 1
MM	number of the month with leading zero, e.g. 01
MMM	abbreviated month name, e.g. Jan
MMMM	full month name, e.g. January
d or D	day of the month without leading zero, e.g. 1
dd or DD	day of the month with leading zero, e.g. 01
ddd	abbreviated name of the day of the week, e.g. Sun
dddd	full name of the day of the week, e.g. Sunday
h	hours (12-hr format) without leading zero
hh	hours (12-hr format) with leading zero
H	hours (24-hr format) without leading zero
HH	hours (24-hr format) with leading zero
mm	minutes
ss	seconds
SSSSSS	microseconds with leading zeros, 000000-999999
p or tt	AM/PM label
z or Z or TZD	time zone label, e.g. UTC
zz or ZZ	time zone offset without colon, e.g. +0100
zzz or ZZZ	time zone offset with colon, e.g. +01:00

*** ## Examples The content body might look like:\ \&#xNAN;*"You started at |DATETIME(audience.start\_time, “HH:mm:ss”, “America/New\_York”)| and finished at |DATETIME(audience.end\_time, “HH:mm:ss”, “America/New\_York”)|."*
The example above shows the full-blown version with all the optional function parameters. The short one would look like: \ \&#xNAN;*"You started at |datetime(audience.start\_time)| and finished at |datetime(audience.end\_time)|."*
The second function parameter specifies the date/time format, and the 3rd one specifies the time zone to use. The time zone can be specified in 2 formats - 'America/New\_York' (this is a universally-accepted representation for US Eastern Time).
Other examples are\ |datetime(audience.end\_time, “HH:mm:ss Z (ZZ)”, audience.timezone)|\ Example result: “04:05:00 PST (-0800)”
|datetime(audience.end\_time, “d/M/yyyy, ZZ, HH:mm:ss”, audience.timezone)|\ Example result: “1/1/2015, -0800, 04:05:00”
|datetime(audience.end\_time, “HH:mm:ss Z (ZZ)”, audience.timezone)|\ Let’s say the audience.end\_time is “2015-06-01 12:05:00” instead of “2015-01-01 12:05:00”\ Example result: “05:05:00 PDT (-0700)”\ \ tz\_timezones\ A list of tz\_timezones can be found here --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://helpdocs.conducttr.com/feature-documentation/designing-and-running/smartwords/functions/datetime-formatting.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.