- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 15, 2023 06:58 AM
Hi everyone,
I need assistance with getting the proper year in an ISO week start date so that I can get a valid week start date. I have the following formula:
DATETIME_PARSE(DATETIME_FORMAT({Date Field}, "W"), "W")
Month and day outputs from this method are accurate, but a year is not. It is stuck in 2023, the current year. Can somebody assist me? It's acceptable if I need to use more than one field to accomplish this, for example, one field to obtain the proper year and one field to obtain the correct day.
Sincerely appreciated!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 01:31 AM
Hm, could you provide a screenshot of your table with the relevant fields as well as an example or two of a date and the output you would want?
