PreviousWeekdayFromDate function

Returns the date of the specified day of the week that is the most recent day before the source date. The day of the week is specified as the full name, for example, thursday, or a three-letter abbreviation, for example, thu.

Namespace

datetime

Input

source date(date|string), day of the week(int|string)

Output

date(date)

Example

If basedate contains the date 2008-08-18 and Thursday is specified, then the two following functions are equivalent, and return the value 2008–08–14:

set-column result datetime:PreviousWeekdayFromDate('2008-08-18', 'thursday') set-column result datetime:PreviousWeekdayFromDate(basedate, 'thu')



Created in 2020 by Google Inc.