Expression to start the week on Sunday

[elan_Bailey]

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.

[Suvrutt_Gurjar]

@elan_Bailey,

Please check if the following expression helps

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

[elan_Bailey]

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

[Steve · Accepted solution]

Try:

DATETIME(TODAY())