I am using the local database feature in AIR 1.5. I have a table which is created by:
"CREATE TABLE IF NOT EXISTS employees (timeAdded Date, name STRING)"
Now lets say that I want every employee added between date1: Date and date2: Date, I would do that by using:
"SELECT * FROM employees WHERE " + date1 + "<timeAdded AND timeAdded<" + date2
This does not work, because the type Date in SQL is a Julian day number (JDN), and date1 and date2 are flash formatted dates. It is not possible to get the JDN of a date through flash. How do I solve the problem?
