DateTime from week number

0
Hey, I have a week number, now it try to find the first day and last day of that specific week if a datetime object. Can someone help my with this how I can do this in a microflow?
asked
1 answers
4

I think you need to look at the “w” pattern when using parseDateTime. This is the week in the year. You’ll also need the year for this to make sense. So for the start date where $WeekOfyear and $Year are string with the week in the year and the year respectively, I think you need 

parseDateTime($WeekOfYear + ' ' + $Year, 'w YYYY')

and the end of the week will be 6 days from this value, so if you saved it in $StartDateTime, you’ll need

addDays($StartDateTime, 6)


I’ve put an example microflow up to show you how this can work.

https://modelshare.mendix.com/models/4296868c-c941-4687-b520-bd9c90cc6a62/start-and-end-date-by-week-of-the-year

answered