# "date" dimension
date_string = str(dim_date["purchase_date"])
# Covert 01/01/2020 to SQL date 2020-01-01
date_purchase = datetime.datetime.strptime(date_string, '%m/%d/%Y').strftime('%Y-%m-%d')
date_vacation = "No vacation"
date_week = datetime.datetime.strptime(date_string, '%m/%d/%Y').strftime('%W')
date_month = datetime.datetime.strptime(date_string, '%m/%d/%Y').strftime('%m')
if "2020-02-15" <= date_purchase and "2020-03-01" >= date_purchase :
date_vacation = "Voorjaarsvakantie"
print (date_purchase, date_vacation, date_week, date_month)
cursor.execute("""
SELECT * FROM dim_date
WHERE date_purchase = '"""+date_purchase+"""'
AND date_vacation = '"""+date_vacation+""""'
AND date_week = '"""+date_week+""""'
OR date_month = '"""+date_month+""""'