Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how I convert the answer in this post number of months in a variable to the number of weeks?
Maybe
Floor( ( D2 - D1 ) / 7 )
Hi Lawrence,
Try this:
SET WeekDiff = Num(((year($2) * 52) + (month($2)*7)+ week($2)) - (((year($1) * 52) + (month($1)*7)+week($1))));