calculate how many weeks from today to a given dat... - Qlik Community

Anonymous · ‎2016-10-13

Hello

I would to know how to calculate how many weeks from today to a given date.

For example as attached,

I used

floor(Interval(Today()-CalendarYMD,'D')/7)

to calculate how many weeks from today to a given date.

But, you can see here, there are different values for days in the same week.

sunny_talwar · ‎2016-10-13

May be try this:

Floor(Interval(Today()-WeekStart(CalendarYMD),'D')/7)

Anonymous · ‎2016-10-13

Sunny T,

It works!

Good to know there is a WeekStart function.

Thanks again

Josh

sunny_talwar · ‎2016-10-13

Hahaha yes, there is WeekStart and WeekEnd functions. Here you can find a list of all date and time related functions

Best,

Sunny