Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Anonymous
Not applicable

How to add hours to DateTime data?

‎12-20-2016 03:11 AM

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?

Labels:
Message 1 of 22
245,108 Views
1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

‎12-20-2016 05:14 AM

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.

Specializing in Power Query Formula Language (M)

View solution in original post

Message 2 of 22
264,656 Views
21 REPLIES 21
quinncallan
New Member
In response to MarcelBeug

‎05-03-2017 04:56 AM

My apologies, i believed my question was still on topic, asking a question about your answer and would enhanse the existing thread

Message 10 of 22
225,798 Views

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

View All