Expression to start the week on Sunday

Hi can anyone help with this expression. I was originally using the code below to start my new challenges pre-populated with a Friday start date.

IFS(WEEKDAY(TODAY())= 7, (TODAY() -1), WEEKDAY(TODAY())= 6, TODAY(), WEEKDAY(TODAY())< 6, TODAY()-(WEEKDAY(TODAY()) +1))

Instead I want to change the pre-populated start date to the current (or preceding) Sunday.

@elan_Bailey,

Please check if the following expression helps

TODAY()-WEEKDAY(TODAY())+1

1 Like

Thanks, I ended up just changing it to NOW().
Is there a way to make it current day at midnight.

So if I create a new entry right now (which for me Mon Feb 10 @ 6:29 am). The entry date and time would show as Mon Feb 10 @ 12:00 am

Try:

DATETIME(TODAY())
2 Likes