need help with date (asp)

gulerbekir · December 18th, 2004, 02:01 AM

Hi

i want to find dates between two dates by using query below.

MinDate= "01."&RMonth&"."&RYear
MaxDate= "31."&RMonth&"."&RYear
Sql="Select * From Absences where ADate>='"&MinDate&"' and ADate<='"&MaxDate&"' and S_No="&No&" order by ADate"

i m living in Turkey, and date format is dd.mm.yyyy when i try to see the page i got type mismatch error

please help me on this porblem

khng · December 18th, 2004, 12:36 PM

Quote:

quote:Originally posted by gulerbekir
Hi

i want to find dates between two dates by using query below.

MinDate= "01."&RMonth&"."&RYear
MaxDate= "31."&RMonth&"."&RYear
Sql="Select * From Absences where ADate>='"&MinDate&"' and ADate<='"&MaxDate&"' and S_No="&No&" order by ADate"

i m living in Turkey, and date format is dd.mm.yyyy when i try to see the page i got type mismatch error

please help me on this porblem

http://www.4guysfromrolla.com/webtec...ate/faq2.shtml

date is know as the most trouble in sql query as different vender have different date format, some used format chose by vender while other used your system date format..........