Power Query
Search…
Date.StartOfDay

Date.StartOfDay

Returns the first value of the day.
function (optional dateTime as nullable any) as nullable any

Description

Returns the first value of the day dateTime. dateTime must be a date, datetime, or datetimezone value.

Category

Date

Examples

Find the start of the day for October 10th, 2011, 8:00AM (#datetime(2011, 10, 10, 8, 0, 0)).
1
Date.StartOfDay(#datetime(2011, 10, 10, 8, 0, 0))
Copied!

datetime(2011, 10, 10, 0, 0, 0)

Last modified 3yr ago