Calculating date based on the week of the year

[Kyleled]

Hello everyone,

I'm trying to calculate date based on two fields: week of the year and year. My plan is to just set the date to the first day of that month

Example data:

Week: 1

Year: 2020

Calculated date: '2020-01-01'

Let me know if this makes sense. I've seen ways to figure out the week of the year based on a date but I'm trying to go the other way around

[atcodedog05 · Accepted solution]

Hi @Kyleled ,

This is a fun scenario.

Here is workflow for it.

Output

Check and let me know if it works for the task.

[Kyleled]

---

@atcodedog05 wrote:

Hi @Kyleled ,

This is a fun scenario.

Here is workflow for it.

Output

Check and let me know if it works for the task.

Brilliant, thanks!

---

[atcodedog05]

Happy to help : )