InLastYearYTD - Built-in Date & Time Function¶

Purpose¶

Returns true if the passed date falls in any date in the last year up to the current date last year. If the current date is 2023-12-08, any date passed that is between 2022-01-01 and 2022-12-08 is valid.

Syntax¶

InLastYearYTD(datetime)

Arguments¶

Returns¶

Boolean

See also¶

• Date
• DateAdd
• DateDiff
• DatePart
• DateValue
• DateSerial
• Day
• Hour
• InAgedToDays
• InLast4WeeksToSunday
• InLast7Days
• InLastFullMonth
• InLastFullWeek
• InLastYearMTD
• InLeapYear
• Minute
• Month
• MonthName
• Now
• Second
• Time
• TimeSerial
• TimeValue
• WeekAgo
• Weekday
• WeekdayName
• Year

Examples¶

Used in a Font Color function¶

If InLastYearYTD({OrderHeader.Order_Date}) Then
    Return drBlack
Else
    Return drRed
End

Used in a filter function¶

return InLastYearYTD({OrderHeader.Order_Date})

Notes¶

• When the argument cannot be converted to a datetime value, a runtime error is generated.