Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this:
Floor(Interval(Today()-WeekStart(CalendarYMD),'D')/7)
Sunny T,
It works!
Good to know there is a WeekStart function.
Thanks again
Josh
Hahaha yes, there is WeekStart and WeekEnd functions. Here you can find a list of all date and time related functions
Best,
Sunny