PureBasic Forums - English

are you talking about a distance or a track algorithm?

hey, thanks for the help, I used the "Like"-option, it was too confusing. The date was like dd.mm.yyyy , the ODBC returns it like yyyy-mm-dd when I make a request like #mm/dd/yyyy# .

But now I´m stuck on creating an output into an *.xls sheet. How can I use the cell C3 (3, 3)?

nope, doesn´t work for me. But the "Like" option works.

Select * From db Where Date Like '06.07.2002'

No Between ...

how can I make a query with dates? I have an old Access file with the coloumns Date and Time, and I want to use the Between clause. But I even can´t get a query if I chose a specific date or time. The Date data look like yyyy-mm-dd 00:00:00 and the Time data look like 1899 etc.

I tried wildcards ...