Date save as zero (0) in the SQLite database

[mozaharul]

In the SQLite insert command the "insert into geo values(calender1.values)" save the date as ticks.

But if I use " insert into geo values(date(calender1.values))" then it saves zero (0) in the database.


Please help


regards

[Erel]

Try:

"insert into geo values('" & date(calender1.values) & "')"

[mozaharul]

It works.
Thank you very much sir.