I need the correct syntax to give me :
- Previous week's Monday's date based on the current date/time using
GETDATE()
- Previous week's Sunday's date based on the current date/time using
GETDATE()
So, based on today's date (14/09/2012) I would want the following:
- Previous Monday's date = 03/09/2012
- Previous Sunday's date = 09/09/2012