Search results

Yeah its an access query on top of an Oracle database. I've never tried the DateAdd function successfully but the query I posted using now() is working as expected. It's just a longer implementation of the same criteria. Either way, thanks for all the help on this one. It's definitely been...

Got it... Had to do some conversions but I think this formula ultimately works: Between CDate(CStr(Month(Now()))+"/"+CStr((Day(Now())-1))+"/"+CStr(Year(Now()))+" 12:00:00 PM") And CDate(CStr(Month(Now()))+"/"+CStr((Day(Now())))+"/"+CStr(Year(Now()))+" 12:00:00 PM") Thanks, Jon

I see... So if I wanted my criteria to be between yesterday 12:00PM and today 12:00 PM I should use something along the lines of: Between (Date()-0.5) And (Date()+0.5) That's producing an error: [Oracle][ODBC][Ora]ORA-01847: day of month must be between 1 and last day of month (#1847)...

Spikepl, That was it, so simple I feel dumb now. Didn't know you could append the time with a simple + like that. Here's the criteria I'm using now. Seems to be working with my initial tests: Between (Now()-1)+#12:00:00 PM# And Now()+#12:00:00 PM# Thanks, Jon

Hey guys, Thanks for the suggestions. marlan, I've looked into using the dateAdd function but I still can't quite figure out how to get that to point back to 12:00:00 PM from a dynamic Now() date. nfk, Your code posted is exactly what I'm trying to do its just getting those dates correct...

Hey guys, I'm having a little trouble figuring out how to create this access query correctly. Long story short, I have a table of data with entry date fields. What I need to do is pull all records from ((Now - 1) @ 12:00 PM) - (Now @ 12:00 PM). I understand the Now() function but I'm having...

That was it! Thanks guys, can't believe i didn't see that before!

Ok so I have a form with a bunch of sub forms all using individual tab indicies and tab stops. Pretty standard. All the tabs work fine until today when I tried to add a new subform. For some reason, all tab settings held equal, when i tab through this subform and get to the last record and hit...