Rounds a DateTime.

NewDateTime := ROUNDDATETIME(Datetime [, Precision][, Direction])



Type: DateTime

The DateTime that you want to round.


Type: BigInteger

This optional parameter determines the precision used when rounding. The default value is 1000, which rounds to the nearest second.

You can only use positive BigIntegers.


Type: Text or Code

This optional parameter specifies how to round the DateTime. The default rounding method is '='. You can change the method by using the following options:

  • '=' rounds up or down to the nearest value (default). Values of 5 or greater are rounded up. Values less than 5 are rounded down.

  • '>' rounds up

  • '<' rounds down

Expand imageProperty Value/Return Value

Expand imageRemarks

Expand imageExample

Expand imageSee Also