>I am having a bit of trouble doing a date search on form entered data.
WOW - I had no idea that there would be so many approaches. I thought on the way into work today to just put zeros in the time and do a 'greater than', but Tony pointed out that it'd be between instead. Hey tony, the date you used is my birthday (not year though <ahem>).
I never would've thought of truncating the date and there seem to be several ways to do that. Interesting that Oracle provides a method for it. Pascal, that third approach, with the dateAdd will work on Oracle?
And yeah, I should've mentioned that it was Oracle.
Thanks Tony, Pascal and Deanna (again).
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- date search Daniel Kessler
- Re: date search Deanna Schneider
- RE: date search Tony Weeg
- Re: date search daniel kessler
- Re: date search Deanna Schneider
- RE: date search Pascal Peters
- RE: date search Tony Weeg
- RE: date search Philip Arnold
- Re: date search Deanna Schneider
- Re: date search daniel kessler
- Re: date search daniel kessler
- RE: date search Pascal Peters
- Re: date search daniel kessler
- OT: Mach-II Michael Haggerty
- Re: OT: Mach-II Bryan F. Hogan
- RE: OT: Mach-II Tony Weeg
- Re: OT: Mach-II stas
- RE: OT: Mach-II Mike Kear
- RE: OT: Mach-II Michael Haggerty
- RE: OT: Mach-II Jeff Langevin