Get correct week number and date

[VladimirKrstic]

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!

[TheTimeSavingCo]

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?