Date.IsInPreviousDay

Updated on

Date.IsInPreviousDay is a Power Query M function that indicates whether the given date(time) value occurs during the previous day, as determined by the system. The function returns a boolean value (true or false).

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Date.IsInPreviousDay( dateTime as any ) as nullable logical

Description

Date.IsInPreviousDay determines if a datetime value occurs during the previous day, based on the current system date and time. Returns false for values within the current day. The dateTime input can be of date, datetime or datetimezone type.

Examples

Determine if the day before the current system time is in the previous day.

// Output: true
Date.IsInPreviousDay( Date.AddDays( DateTime.FixedLocalNow(), -1 ) )

Other functions related to Date.IsInPreviousDay are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-isinpreviousday