Skip to main content

Get correct week number and date

  • March 15, 2023
  • 1 reply
  • 44 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!

 

      This topic has been closed for replies.

      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