Topic: Current Date as Parameter Default Posted: 19 Apr 2011 at 9:47am
Anyone know how I can set up date parameter default values based on the current date. I need to be setup start & End Date parameters that users can change, but are set to default values based off the curent date. In SQL it would something like this:
Select item, itemname, recvdate, CalDate, CalDue, manufnm, model
From ident_LIMS
Where CalDue > GetDate() and CalDue < (GetDate() +30)
I cant beleive there is not something simple that I am missing.
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
IP Logged
