Rounds a DateTime.
NewDateTime := ROUNDDATETIME(Datetime [, Precision][, Direction]) |
Parameters
- Datetime
-
Type: DateTime
The DateTime that you want to round.
- Precision
-
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.
- Direction
-
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
-