I have Week Number (starting on Sunday always), Month and year
I need to convert it to a Date
I was thinking something like this
but how do I work the week number in?
Below formula should work
DATEADD('week',[F Week], DATE("01"+"01"+str([F Year])))
DATE("01"+"01"+str([F Year]) # this gives you first of year i.e. 1 jan 2017 .
Then we add weeks to this value
I must be missing something, here is what I am getting
See Calculation3 in the attached. (Calc1->calc2->Calc3) is a progression of how I arrived at Calc3.)
i think i pasted the wrong screenshot there.
But let me ask. When should be the date for below values?
The First week of year never comes in March
Mar 2017 OR Mar 2018 does not have 5 Sundays.
Retrieving data ...