Hello! Does anyone know how you can transform a week number and a year number to a date?
Solved
Making a date from a week and year number
Best answer by Mohamed_Swella1
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")
+17Hi @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")
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.