utils/date_utils.py

# %%
from datetime import datetime, date

def convert_date_format(date_input):
    if isinstance(date_input, (datetime, date)):
        return datetime.strptime(date_input.strftime("%m/%d/%Y"), "%m/%d/%Y").strftime("%Y-%m-%d")
    elif isinstance(date_input, str):
        return datetime.strptime(date_input, "%m/%d/%Y").strftime("%Y-%m-%d")
    else:
        raise ValueError("Unsupported date format")