Skip to main content

Get correct week number and date

  • March 15, 2023
  • 1 reply
  • 31 views
V
Forum|alt.badge.img+1

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!

 

    1 reply

    TheTimeSavingCo
    Forum|alt.badge.img+31

    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?

    Adam, Airtable Consultant - thetimesaving.company


    Terms & ConditionsAccessibility statement