Forum Discussion
How to add hours to DateTime data?
I have a column DateTimeCreated (Example: 2016-12-20 19:40) and I want to add 10 hours to this resulting in 2016-12-21 05:40. Is this possible?
You can add a duration to a datetime field, e.g. if your fieldname is "DateTime":
[DateTime] + #duration(0,10,0,0))
The arguments of#duration are days, hours, minutes, seconds.
Hi
How do you add 10hrs to all dates in the list instead of just one?
Please don't hijack other topics for your own question, but start a new topic instead.
And don';t forget to react to replies you get, maybe give kudos, mark replies as answer, which you still have to do for your for your first and only topic so far, raised in April 2016.
My apologies, i believed my question was still on topic, asking a question about your answer and would enhanse the existing thread