Hi there,
I installed the newst version of asprunner and I tried to make a small project that search simple Access file in ASP. Eveything is OK except on thing which is as follow : When I go to advance search and choose to search "between" to search about a period between two times for example 10:00:00 and 12:00:00 , I get this Error message:
Error number -2147217900
Description [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '(1=1 and [MinOfTime] >=#1899-12-30 am# and [MinOfTime]<=#1899-12-30 am#)'.
SQL select [SumOfQuantity], [CountOfCode], [Code], [Company], [Kind], [SumOfTot], [LastOfPrice], [MaxOfTime], [FirstOfPrice], [MinOfTime], [MinOfTot], [MaxOfTot] From [Hawameer] where (1=1 and [MinOfTime] >=#1899-12-30 am# and [MinOfTime]<=#1899-12-30 am#)
as you can see the "MinOfTime" is a date/time field
Any solution ??
