Oct 25, 2023 02:53 PM
Basically,
I have a field that lists days of the week with no reference to date. I have tasks that need to be done on a particular day. Would like to another field to automatically update itself with date of the current week for that given day.
Is this possible?
Thanks
Solved! Go to Solution.
Oct 25, 2023 06:30 PM
For example, if you always display this Friday(5), the formula would look like this.
DATEADD(DATETIME_PARSE(WEEKNUM(TODAY()),"w"),5,"day")
0 is Sunday and 6 is Saturday.
Oct 25, 2023 06:30 PM
For example, if you always display this Friday(5), the formula would look like this.
DATEADD(DATETIME_PARSE(WEEKNUM(TODAY()),"w"),5,"day")
0 is Sunday and 6 is Saturday.
Oct 31, 2023 04:37 AM
Thank you @Sho much! This worked like a charm.
Dec 03, 2023 05:24 PM
Exactly what I was looking for. Thanks!