+3Basically,
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
Best answer by Sho
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.
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.
+3For 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.
Thank you @Sho much! This worked like a charm.
+1For 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.
Exactly what I was looking for. Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.