Skip to main content

​
Find Earliest Date

Returns the earliest date from a given list of dates.
ParameterDescription
Date ListA comma separated list or JSON array containing date strings.

Each date string can be in a variety of common date formats. For example:
  • YYYY-MM-DD
  • DD/MM/YYYY
  • YYYY-MM-DDTHH:MM:SS
  • YYYY-MM-DDTHH:MM:SS.sssZ
  • YYYY-MM-DDTHH:MM:SS.sss+hh:mm
  • YYYY-MM-DDTHH:MM:SS.sss-hh:mm
  • Unix Timestamp
Note: Input dates that are Timezone Aware cannot be used along with Timezone Naive dates. All dates should either be in UTC format or have a clearly defined timezone.

​
Find Latest Date

Returns the latest date from a given list of dates.
ParameterDescription
Date ListA comma separated list or JSON array containing date strings.

Each date string can be in a variety of common date formats. For example:
  • YYYY-MM-DD
  • DD/MM/YYYY
  • YYYY-MM-DDTHH:MM:SS
  • YYYY-MM-DDTHH:MM:SS.sssZ
  • YYYY-MM-DDTHH:MM:SS.sss+hh:mm
  • YYYY-MM-DDTHH:MM:SS.sss-hh:mm
  • Unix Timestamp
Note: Input dates that are Timezone Aware cannot be used along with Timezone Naive dates. All dates should either be in UTC format or have a clearly defined timezone.

​
Get Epoch Time

Gets an epoch time specific or relative to a given time.
ParameterDescription
TimeCan be a specific date and hour, or a relative range.
Epoch FormatWhether to display the epoch time as seconds or milliseconds.

​
Get Time Difference Between Timestamps

Get Time Difference, in Seconds, Between Two Different Timestamps.
ParameterDescription
Timestamp 1The first Timestamp. Can be a specific date and hour, or a relative range.
Timestamp 2The second Timestamp. Can be a specific date and hour, or a relative range.

​
Get Timezone

Gets the timezone identifier from a latitude/longitude pair or from the current workspace. Can be used in conjunction with the Get Timezone Offset to get the amount of seconds after GMT.
ParameterDescription
Location TypeChoose how the location for the timezone should be provided.
LatitudeThe degrees latitude of the desired position to get the time for.
LongitudeThe degrees longitude of the desired position to get the time for.

​
Get Timezone Offset

Gets the timezone offset (in seconds) relative to GMT from a IANA timezone identifier.
ParameterDescription
Timezone IdentifierThe IANA timezone identifier, usually provided as {Country}/{City}.
If given UTC, returns the offset of UTC time (0).
Visit Wikipedia for a frequently updated list of names.
For the most updated list, visit the IANA registry and download the distribution file.