- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 31, 2023 04:37 AM
Thank you @Sho much! This worked like a charm.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 03, 2023 05:24 PM
Exactly what I was looking for. Thanks!