Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Parameter Mask

Status
Not open for further replies.

rafeman

Technical User
Oct 20, 2004
66
GB
Hi, I know you cannot mask dates in parameters but can put a start / end date in for a range of values. I need the user to only be able to select the last sunday of every week. Is this possible or do I have to put a warning on the report if this isn't selected? Thanks
 
There is only one Sunday per week. You could just set up your record selection formula to change the selection (if necessary) to a Sunday:

{table.date} = {?Parm}-dayofweek({?Parm})+1

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top