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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing datatype of sql parameter passed to Crystal

Status
Not open for further replies.

Luvsql

Technical User
Apr 3, 2003
1,179
CA
I have created a stored procedure in sql server with 2 datetime parameters (cannot have it just date) and in the proc it converts the data to ignore the time so the restrictions run properly. HOwever, when in Crystal, the users are prompted with both a date and a time dropdown, which causes confusion. The time is irrelevant to the proc or the report

Can this be changed so that when the user is prompted, they only get the calendar and not the time? CR 9. Don't have the convert datetime to date option.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top