> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Formatting date and time

> How to format date and time when working with Zapier.

Dates and times in SuperOffice follow the ISO standard format: 'yyyy-mm-ddThh:mm:ssZ', where Z indicates the UTC time zone.

A Zapier Formatter helper step can be used to convert this value into a different format.

![Action/Search -screenshot][img1]

## Select formatter

A formatter can, for example, convert an appointment start date value from the default format into an American-style date such as '06/19/2019'.

![Select Formatter by Zapier Action -screenshot][img2]

## Adjust value

The Formatter in Zapier provides three transformation options for handling date and time values:

![Add/Subtract Time -screenshot][img3]

1. **Add/Subtract Time** - Manipulates a date or time value by adding or subtracting days, months, years, hours, minutes, or seconds.

   ![Add/Subtract Time -screenshot][img4]

2. **Compare Dates** - Calculates the duration between two dates in days, hours, minutes, and seconds, and determines whether the dates are identical.

   ![Compare Dates -screenshot][img5]

3. **Format** - Converts a date or time value into a different format or style.

   ![Format -screenshot][img6]

[img1]: /media/loc/en/integrations/zapier/formatter-step.png

[img2]: /media/loc/en/integrations/zapier/select-formatter.png

[img3]: /media/loc/en/integrations/zapier/tranform-date-configure.png

[img4]: /media/loc/en/integrations/zapier/add-subtract-option-date.png

[img5]: /media/loc/en/integrations/zapier/compare-dates.png

[img6]: /media/loc/en/integrations/zapier/format-date.png