Hey,
I am writing a Web-based Crystal Report application. Basically, I want the user to select a date range before the report loads.
I have two calendar controls, one for the beginning date, one for the end date(i will change this eventually).
The user selects the dates, then I need to send those dates as parameters to the Report.
The problem is:
When I select a particular day in the calendar, the calendar.selecteddate.date looks something like this "30/apr/2006"
I use Format() to convert it to look like this "yyyy, mm, dd".
Problem is; the conversion does not recognize the month name "apr" and thus it brings back something like this: "2006, 00, 30", so when i send this data in the parameter I get an error saying that the month can only be a number between 1 and 12.
Basically my question is, Is there a way to change the format for calendar.selectdate.date, say in a totally numeric way(Ex 01/04/2006), not with month name( Ex 01/apr/2006)?
I am writing a Web-based Crystal Report application. Basically, I want the user to select a date range before the report loads.
I have two calendar controls, one for the beginning date, one for the end date(i will change this eventually).
The user selects the dates, then I need to send those dates as parameters to the Report.
The problem is:
When I select a particular day in the calendar, the calendar.selecteddate.date looks something like this "30/apr/2006"
I use Format() to convert it to look like this "yyyy, mm, dd".
Problem is; the conversion does not recognize the month name "apr" and thus it brings back something like this: "2006, 00, 30", so when i send this data in the parameter I get an error saying that the month can only be a number between 1 and 12.
Basically my question is, Is there a way to change the format for calendar.selectdate.date, say in a totally numeric way(Ex 01/04/2006), not with month name( Ex 01/apr/2006)?