Date Manipulations in SQL
Budget: $10 – $30 USD
Need to create a start date and end date.
Start date: first Saturday of every month
End date: latest Saturday (based on current date)
Condition: Once the month changes and we are in the first week of current month, the start date should change to first Saturday of previous month
Start date: first Saturday of every month
End date: latest Saturday (based on current date)
Condition: Once the month changes and we are in the first week of current month, the start date should change to first Saturday of previous month