NEXT_DAY_OF_WEEK

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

An expression producing a date and a string identifying the day

Object.NextDay = NEXT_DAY_OF_WEEK (CURRENT_DATE, 'Tuesday')  
/** This returns next Tuesday from current date**/ 
  • Last modified: 2023/05/09 01:13