Getting the date of the first day of the week

Question

I have records in a table which have a date field.

I would like to query the table so that the records returned are only the Sunday's date of a given week.

How could I use python's datetime library to achieve this? Thanks.

Answer 1

Thanks @PavSidhu and editors of that answer. Building further on that answer:

If your start of week is Sunday

import datetime
datetime.datetime.today() - datetime.timedelta(days=datetime.datetime.today().isoweekday() % 7)

If your start of week is Monday

import datetime
datetime.datetime.today()  - datetime.timedelta(days=datetime.datetime.today().weekday() % 7)

If you want to calculate start of week for a future date

import datetime
from dateutil.relativedelta import relativedelta

# 5 days ahead of today
future_date = datetime.datetime.today() + relativedelta(days=5)

# If Start of Week is Monday
print(future_date - datetime.timedelta(days=future_date.weekday() % 7))

# If start of week is Sunday
print(future_date - datetime.timedelta(days=future_date.isoweekday() % 7))

Diff: When start of week is Monday, we are using weekday() instead of isoweekday()

• isoweekday() - Monday is 1 and Sunday is 7
• weekday() - Monday is 0 and Sunday is 6