Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restrict Date Parameter Expand / Collapse
Author
Message
Posted Monday, November 26, 2012 8:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 10:51 AM
Points: 70, Visits: 371
Hello,

Is there any way i can restrict calendar ( Parameter )to go back 1/11/2012. You can't choose date before 1st Nov, or if you choose then gives you error message, something like that.

Thanks.
Post #1388661
Posted Monday, November 26, 2012 10:58 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 3:52 PM
Points: 1,485, Visits: 1,035
No, I do not believe you can restrict the a Datetime parameter to a specific date range.

You can create a query, or a list in the Available values section of the parameter, but it then makes it a dropdown, instead of a calendar control.

Similar thread
http://www.sqlservercentral.com/Forums/Topic537763-145-1.aspx
Post #1388735
Posted Tuesday, November 27, 2012 1:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 10:51 AM
Points: 70, Visits: 371
Thanks Ray
Post #1389009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse