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!