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.
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.