Hello
I tried these both option on a date for example 1/1/2022 but I do not see any difference. What they do exactly. Thank you very much.
Hello
I tried these both option on a date for example 1/1/2022 but I do not see any difference. What they do exactly. Thank you very much.
When applied to a DateTime they return the spcified date, with a time of 0:00:00 or 23:59:59.9999999 respectively.
For example:
Date.StartOfDay(#datetime(2022,01,26,5,58,32) returns #datetime(2022,1,26,0,0,0)
Date.EndOfDay(#datetime(2022,01,26,5,58,32) returns #datetime(2022,1,26,23,59,59.9999999)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks