Hi All,
I'm using a procedure in my report and in that i'm passing todate and from date prompts.
in the report i have to use a date prompt (calendar), But when i'm passing values using dateprompt, it's not showing any data.
i figured out the problem is when i'm using a date prompt the value getting passed is like this : Jan 7, 2007 12:00:00 AM
but my procedure accepts value in this format : 1/7/2007 ie, mm/dd/yyyy.
can anyone give me the javascript for changing the format of the calendar date to mm/dd/yyyy
Thanks in Advance
I've had to do something similar. I made the conversion in the stored procedure. Here's a SQL Server example.
CREATE PROCEDURE TEST
(
@StartDate DateTime
)
AS
DECLARE @StartDateText VarChar(20)
SELECT @StartDateText = Convert(VarChar, DatePart(DD, @StartDate)) + '/' + Convert(VarChar, DatePart(MM,@StartDate)) + '/' + Convert(VarChar, DatePart(YYYY, @StartDate))
PRINT @StartDateText
GO
Thank you ... I'll try this