---
title: "Date Times"
slug: "date-times-filter"
updated: 2026-02-25T17:26:49Z
published: 2026-02-25T17:26:49Z
canonical: "learn.servitly.com/date-times-filter"
---

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

# Date Times

Transform and displays date and time values in different ways and formats.

![Date Times](https://components-manager.servitly.com/components/DateTimes_1/IMAGES/_screenshot?owner=AG_Servitly)

This filter and its variants can be applied to *metrics* and *properties* of type *DATE*, *INTEGER*, *LONG* or *FLOAT*.

Depending on the variant options, the underlying numeric value is converted to a date or period and then formatted as desired.

# Filter Variants

The set of predefined filter variants that can be used to format values.

| **Date and Time** |
| --- |
| *Date and Time or short period* | Converts the milliseconds to a localized date and time or to a period in the case of less than 24 hours. **Name**: *millisToDateTimeOrShortPeriod* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `now - 6h -> 6 hours ago.` `1526898865000 -> May 21, 2018 10:34:25.` `null or empty -> ""` |
| *Date or short period* | Converts the milliseconds to a localized date or to a period in the case of less than 30 days. **Name**: *millisToDateOrShortPeriod* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `now - 6d -> 6 days ago.` `1526898865000 -> May 21, 2018.` `null or empty -> ""` |
| *HH:mm* | Converts the milliseconds to a formatted time. **Name**: *millisToTime2* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1526898865000 -> 10:34` `null or empty -> ""` |
| *HH:mm:ss* | Converts the milliseconds to a formatted time. **Name**: *millisToTime* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1526898865000 -> 10:34:25` `null or empty -> ""` |
| *MMM dd, yyyy* | Converts the milliseconds to a localized date. **Name**: *millisToDate2* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1619628734000 -> May 21, 2018` `null or empty -> ""` |
| *yyyy-MM-dd* | Converts the milliseconds to a localized date. **Name**: *millisToDate* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1526898865000 -> 2018-05-21` `null or empty -> ""` |
| *yyyy-MM-dd HH:mm:ss* | Converts the milliseconds to a localized date and time. **Name**: *millisToDateTime* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1526898865000 -> 2018-05-21 10:34:25` `null or empty -> ""` |
| **Duration** |
| *2:06* | Converts the time in millis to a formatted duration expressed in hours and minutes. **Name**: *millisToTimePeriod2* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `7593000 -> 2:06` `null or empty -> "-"` |
| *2:06:33* | Converts the time in millis to a formatted duration expressed in hours, minutes and seconds. **Name**: *millisToTimePeriod* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `7593000 -> 2:06:33` `null or empty -> "-"` |
| *2d 6h 33m* | Converts the milliseconds to a formatted duration. **Name**: *millisToPeriod* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `109980000 -> 2d 6h 33m` `null or empty -> "-"` |
| *Days (###)* | Converts the milliseconds to days. **Name**: *millisToDays* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *INTEGER* `86400000 -> 2` `null or empty -> 0` |
| *Days 3 \| Hours 4 \| Minutes 1* | Converts the milliseconds to period displayed in a table with units as headers. **Name**: *millisToTimeUnits* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *HTML* `273666000 -> Days 3 \| Hours 4 \| Minutes 1` `null or empty -> "-"` |
| *Hours (### h)* | Converts the milliseconds to hours with unit, returning "0" as default. **Name**: *millisToHours4* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122400000 -> 34 h` `null or empty -> 0 h` |
| *Hours (### hours)* | Converts the milliseconds to hours with unit, returning "0" as default. **Name**: *millisToHours3* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122400000 -> 34 hours` `null or empty -> 0 hours` |
| *Hours (### or '-')* | Converts the milliseconds to hours, returns "-" as default. **Name**: *millisToHours* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122400000 -> 34` `null or empty -> "-"` |
| *Hours (###)* | Converts the milliseconds to hours, returns "0" as default. **Name**: *millisToHours2* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *INTEGER* `122400000 -> 34` `null or empty -> 0` |
| *Hours (###.# hours)* | Converts the milliseconds to hours with unit, returning "0" as default. **Name**: *millisToHoursNotApproximate3* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122460000 -> 34.5 hours` `null or empty -> 0 hours` |
| *Hours (###.#)* | Converts the milliseconds to hours, returns "0" as default. **Name**: *millisToHoursNotApproximate2* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *FLOAT* `122400000 -> 34.5` `null or empty -> 0` |
| *Hours to 'Days 3 \| Hours 4 \| Minutes 1'* | Converts the time in hours to period displayed in a table with units as headers. **Name**: *hoursToTimeUnits* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *HTML* `76.02 -> Days 3` `Hours 4` `Minutes 1` `null or empty -> "-"` |
| *Minutes (###)* | Converts the milliseconds to minutes. **Name**: *millisToMinutes* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *INTEGER* `122400 -> 2` `null or empty -> 0` |
| *Minutes (###.#)* | Converts the milliseconds to minutes. **Name**: *millisToMinutesNotApproximate* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *FLOAT* `122400 -> 2.22` `null or empty -> 0` |
| *Seconds (###)* | Converts the milliseconds to seconds. **Name**: *millisToSeconds* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *INTEGER* `122400 -> 2` `null or empty -> 0` |
| *Seconds (###.#)* | Converts the milliseconds to seconds. **Name**: *millisToSecondsNotApproximate* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *FLOAT* `122400 -> 2.22` `null or empty -> 0` |
| *Seconds to '2d 6h 33m'* | Converts the time in seconds to a formatted duration. **Name**: *secondsToPeriod* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `109980 -> 2d 6h 33m` `null or empty -> "-"` |
| *Seconds to hours (### h)* | Converts the time in seconds to hours with unit. **Name**: *secondsToHours3* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122400 -> 34 h` `null or empty -> 0 h` |
| *Seconds to hours (### hours)* | Converts the time in seconds to hours. **Name**: *secondsToHours2* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122400 -> 34 hours` `null or empty -> 0 hours` |
| *Seconds to hours (###)* | Converts the time in seconds to hours without decimals. **Name**: *secondsToHours* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *INTEGER* `122400 -> 34` `null or empty -> 0` |
| **Period** |
| *6 months* | Converts the past time in millis to a relative formatted period. **Name**: *millisToRelativePeriodNoSuffix* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1614519061000 -> 6 months` `null or empty -> "-"` |
| *6 months ago* | Converts the past time in millis to a relative formatted period. **Name**: *millisToRelativePeriod* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `1614519061000 -> 6 months ago` `null or empty -> "-"` |
| *Hours (### hours)* | Computes the difference in millis between the given UTC time and now, and returns the number of elapsed hours with unit, returns "0" as default. **Name**: *millisToHours3Relative* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *STRING* `122400000 -> 34 hours` `null or empty -> 0 hours` |
| *Hours (###)* | Computes the difference in millis between the given UTC time and now, and returns the number of elapsed hours, returns "0" as default. **Name**: *millisToHours2Relative* **Input Types**: *INTEGER, NUMBER, DATE* **Output Type**: *INTEGER* `122400000 -> 34` `null or empty -> 0` |