Date.IsInCurrentDay

What is the Date.IsInCurrentDay function?

The Date.IsInCurrentDay function is a Power Query M function that can be used to determine if a given date falls within the current day. It takes a single argument, which is the date that needs to be checked. If the date falls within the current day, the function returns true. If the date does not fall within the current day, the function returns false.

How does the Date.IsInCurrentDay function work?

The Date.IsInCurrentDay function works by first retrieving the current date and time using the DateTime.LocalNow function. This returns a datetime value that represents the current date and time on the computer that is running the Power Query query.

Next, the function extracts the date portion of the current datetime value using the Date.From function. This returns a date value that represents the current date.

Finally, the function compares the input date to the current date by checking if the input date is equal to the current date using the Date.Equals function. If the input date is equal to the current date, the function returns true. Otherwise, it returns false.

Using the Date.IsInCurrentDay function

The Date.IsInCurrentDay function can be very useful when working with date ranges in Power Query. For example, you may want to filter a table to only include rows where the date falls within the current day. To do this, you can use the Date.IsInCurrentDay function in combination with the Table.SelectRows function.

Here’s an example of how this can be done:

let

Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(“i45WMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWIVkZUeD0pMLCvVi1WqZgB”, BinaryEncoding.Base64)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#”Date” = _t]),

#”Changed Type” = Table.TransformColumnTypes(Source,{{“Date”, type date}})

in

#”Changed Type”

let

Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(“i45WMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWMlSK1YlWIVkZUeD0pMLCvVi1WqZgB”, BinaryEncoding.Base64)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#”Date” = _t]),

#”Changed Type” = Table.TransformColumnTypes(Source,{{“Date”, type date}}),

#”Filtered Rows” = Table.SelectRows(#”Changed Type”, each Date.IsInCurrentDay([Date]))

in

#”Filtered Rows”