RoundTime

Description

Rounds a date field down to the nearest second. A new column is created for the results.

Use

  • Argument:
    • Select an argument. (Date) 
  • Output field name:
    • Enter an output field name.

Example

Date valueRoundTime() returns
2022-04-01 08:22:34.3452022-04-01 08:22:34.000
2022-04-01 08:22:34.7892022-04-01 08:22:34.000

Hero Platform_ Example

An example of this function can be found in Hero Platform_'s library of examples.

Download the example titled "function_RoundTime" to see an example of this function. 

Type

Formulas