InLastFullMonth - Built-in Date & Time Function¶

Purpose¶

Returns true if the specified date expression is in the last full month. This means that when the current month is 1, the function returns true when the month from the passed datetime is 12.

Syntax¶

InLastFullMonth(datetime)

Arguments¶

Returns¶

Boolean

See also¶

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

Example¶

Used in a Font Color function¶

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

Used in a filter function¶

return InLastFullMonth({OrderHeader.Order_Date})

Notes¶

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