checking for Date values in where(select) stateme

x087

New Member
I am unable to select a particular record, Actually I am selecting all the records where the start date is todays date, this is what I wrote :<BR><BR>Select * from Schedule where StartDate = "& checknowDisplay &"<BR><BR>where checknowdisplay is current date (6/7/2002) format. <BR>--------------------------------1<BR>and it is giving this error<BR><BR>System.InvalidCastException: Specified cast is not valid<BR><BR>So what might be the problem? plz help me outUse Cdate function from ASP.... or use the appropriate Datatype casting.
 
Back
Top