
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 02:39 AM
Hello! Does anyone know how you can transform a week number and a year number to a date?
Solved! Go to Solution.
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 03:48 AM
Hi @Vito_Kloots ,
Welcome to Airtable Community!
You can use this formula to get the date you need
DATEADD(DATETIME_PARSE("1/1/"&{Year Field}),{Week Field},"weeks")
Reply
1 Reply 1

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 03:48 AM
Hi @Vito_Kloots ,
Welcome to Airtable Community!
You can use this formula to get the date you need
DATEADD(DATETIME_PARSE("1/1/"&{Year Field}),{Week Field},"weeks")
Reply
