One of the ways that Adobe modified the SQLite database is to have added a date
datatype. If you use that, I would think that it would also support standard
SQL such as the between operator. Also,you should be able to read from the
database field directly back into a date chooser control. Similarly, if you
then upload data from the local database to a remote database, it should
correctly map onto a date field in the remote database.
----- Original Message ----
From: bredwards358 <[EMAIL PROTECTED]>
To: flexcoders@yahoogroups.com
Sent: Tuesday, July 15, 2008 8:35:36 AM
Subject: [flexcoders] Finding a date between dates
Sounds like a simple question and easily answered by a search, but
considering my own "search-fu" and not really finding anything
specifically relating to my question after my search I decided just to
post this.
In the app I'm working on, the user can print out reports by selecting
two dates and getting info on orders placed between those two dates.
How it works thus far is that the user picks the two dates from two
date chooser controls, and clicks the button. How the report itself is
generated and displayed doesn't apply here, I just need to figure out
how to get the info I need from the database.
All my dates are saved in the database(SQL Lite as text) using
something like this:
transactionStatemen t.parameters[ ":dateUpdated" ] = new Date().toString( );
This keeps it in the format the user is most familiar with. However
I'm not exactly sure how comparisons can be done to find a date
between too others since they're not exactly numbers. Basically this
all boils down to, what do I need to do to find all dates which fall
between two selected dates?
Thanks in advance,
Brian Ross Edwards,
Tech-Connect LLC
