Power Query
published
Search
⌃K

Date.IsInYearToDate

Date.IsInYearToDate

Indicates whether this date occurs during the current year and is on or before the current day, as determined by the current date and time on the system.
function (optional dateTime as nullable any) as nullable any

Description

Indicates whether the given datetime value dateTime occurs during the current year and is on or before the current day, as determined by the current date and time on the system.

Category

Date

Examples

Determine if the current system time is in the year to date.
Date.IsInYearToDate(DateTime.FixedLocalNow())
true