Loading

Error string has not valid datetime?

Santhosh K S

14y3.4k

Hi...

in reportviewer i'm goning to send startdate and end date of type string(yyyy/mm/dd format) to stored procedure,
In table, Starttime and endtime are DATETIME datatype,IN table datetime in dd/mm/yyyy format.

when i click buton report show An error has occurred during report processing.String was not recognized as a valid DateTime.? Error
Please help me
thanks in advance.............

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
Accepted answer
hi,

I think you can use cast(startdate as datetime) in where condition in SP.

select * from table1 where startdate>= cast(startdate as datetime) and enddate <= cast(enddate as datetime).

hope this will help you.
Santhosh K S14y ago
where i used that convertion,is it in Sp or .cs file
Kunal Vaishya14y ago
Dear you Must get the date like this formate MM/dd/yyyy
its sql Formate

if it set the

Select COnvert(varchar ,Getdate(),101)