Difference between weeks in a variable

[lbunnell]

Does anyone know how I convert the answer in this post number of months in a variable to the number of weeks?

[Clever_Anjos]

Maybe

Floor( ( D2 - D1 ) / 7 )

[deniscamh]

Hi Lawrence,

Try this:

SET WeekDiff = Num(((year($2) * 52) + (month($2)*7)+ week($2)) - (((year($1) * 52) + (month($1)*7)+week($1))));