PREV_DAY_OF_WEEK

Returns the previous day of the week closest to the specified date

An expression producing a date and a string identifying the day

Object.PrevDay = PREV_DAY_OF_WEEK (CURRENT_DATE, 'Tuesday')  
/** This returns previous Tuesday from current date*/ 
  • Last modified: 2023/05/09 01:16