PREVIOUS_DAY

Returns the date of the previous specified weekday before a given date.

Analyze Syntax

func.previous_day(<date>, <weekday>)

Analyze Examples

func.previous_day('2024-06-15', 'Monday')

┌──────────────┐
 '2024-06-10'  
└──────────────┘

SQL Syntax

PREVIOUS_DAY(<date>, <weekday>)

SQL Examples

SELECT PREVIOUS_DAY('2024-06-15', 'Monday');

┌────────────┐
 2024-06-10  
└────────────┘