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)).
Date.StartOfDay(#datetime(2011, 10, 10, 8, 0, 0))

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

Copy link
On this page
Date.StartOfDay
Description
Category
Examples