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.
Solved! Go to Solution.
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())
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |