InLastFullWeek - Built-in Date & Time Function¶

Purpose¶

Returns true if the specified date expression is in the last full week (Sunday to Saturday).

Syntax¶

InLastFullWeek(datetime)

Arguments¶

Returns¶

Boolean

See also¶

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

Example¶

Used in a Font Color function¶

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

In a filter function¶

return InLastFullWeek({OrderHeader.Order_Date})

Notes¶

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