This content has been marked as final. Show 2 replies
I am trying to write a macro that will automatically select the last 13wks when a button is clicked.
I have tried
"PickupWkStart"). Select ">=weekstart(Today(), 0, -1)-13"] ]
I found this selects every week availabel not just the ones i want. Any ideas?
The PickupWkStart field is just teh sunday of the week in standard MM/DD/YYYY format.