Topic: Week Commencing Parameters Posted: 22 Jul 2014 at 9:49pm
Hi - I am creating a timesheet report and wish to have a parameter which allows them to choose the week commencing date (always a Monday). I can't work out how to do this? Anybody help?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Jul 2014 at 5:26am
I would think that you could build a command or a stored proc that would return all the monday dates for month/year...at least that is what I would try.
I know, pretty vague. In a proc, it is not too much work, to return a table of dates using dateadd.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum