dates for given week

hillman · Post by **hillman** » Thu Dec 14, 2006 10:01 am

Is there an easy way in Vortex to calculate the first and last days of a given week (number). For example, if I know that the current week is week no. 50, how can I calculate that Monday is the 11th December and Friday is the 15th?

(The other way around is easy enough, but I can't figure how to arrive at a timestamp from just the week number...)

hillman · Post by **hillman** » Wed Dec 20, 2006 5:27 am

Thanks for your help John, but when I try that I get:

Invalid calendar rule syntax `every Monday' in the function vx_calrulenext

We're running version 5.1.11 so I think it should work?

hillman · Post by **hillman** » Wed Dec 20, 2006 11:04 am

I wrote my own function which does it the hard way!

(It might not be the most elegant method, but it works, so I'll post it incase anyone else is searching for this).


<strfmt %at "%Y-01-01" now>
<$startyear = (convert($ret, 'date'))>


<strfmt %at "%w" $startyear>
<$firstday=$ret>


<$offset = (-2 - $firstday)>


<strfmt %at "%U" now>
<$currentweek=(-1 + $ret)>
<$offset = ($offset + ($currentweek * 7))>


<$secs = ($offset * 86400)>


<$lastfriday = ($startyear + $secs)>
<$nextthursday = ($lastfriday + (6 * 86400))>

(This version calculates the previous Friday and the following Thursday of the current week, simple because that's the date range we use, but could easily be ammended to do Mon-Fri or Mon-Sun etc)...

Post by **mark** » Wed Dec 20, 2006 12:01 pm

This will give the previous friday and it's following thursday.

<$Friday=(convert( '-friday' , 'date' ))>Friday=$Friday
<$Thursday=($Friday + (6 * 86400))>Thursday=$Thursday