I have a need for a query selecting on date being between <this> and <that> dates set in a form by the user. No problem there.
Except the dates are stored in the oracle database as varchar strings ddmmyyyy. I can't see how to select based on dates in that format, can you? I'm not going to be selecting on specific dates, but between date values, or older than a specified date. Any ideas on how I can SELECT * from TABLENAME if DATE less than <form.date> ? OR date between <this> and <that>? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1747 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
