Add minutes to a date

[FranckG]

Hi,

I’d like to add minutes to a datetime and I don’t know how to do it.

DEP_PLANNING_DATE (date): ‘2015-01-19 09:00:00’

Temps_format (minutes) : ‘00:51:00’

I’d like: ‘2015-01-19 09:51:00’

I tried to do this:

DateTimeAdd([DEP_PLANNING_DATE],[temps_format],"minutes")

Error: Formula (71): Parse Error at char(0): Argument 2 of DATETIMEADD is not an integer (Expression #1)

thanks,

Franck

[MarqueeCrew · Accepted solution]

You'll want to add 51 minutes instead. The 51 should be an integer.

That should do the trick. The format of the datetimeadd will work with temps_format containing the integer of 51.

Cheers,
Mark

[FranckG]

Thanks for your reply.