DateAdd

Adds a specified interval to a Databox value date.

Add a specific interval to a date. Supported intervals include...

  • s = Seconds

  • n = Minutes

  • h = Hours

  • d = Days

  • m = Months

  • q = Quarters

  • ww = Weeks

  • yyyy = Years

Expression
Databox Value
Result

DateAdd(12,"m")

15-10-2023 08:00pm

15/10/2024 20:00:00

DateAdd(10,'d') AsDate Format('dd/MM/yyyy')

01/08/2023

11/08/2023

Last updated