Alright, thanks I'll give that a shot. If something's amiss then I'll come back with more questions
--- In [email protected], Sid Maskit <[EMAIL PROTECTED]> wrote: > > 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: [email protected] > 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 >
