but if i change my txtServicingWorkHoursEndDate to anywhere between 1 dec to 11 dec it doesn't work. meaning no records shown - even the ones from 28 to 30 nov which was showing properly previously. even if i use 01 dec or 1 dec 2012 or 01 dec 2012. this is quite strange. any possible explanations?
btw datevalue is giving me the correct dates - i've tested it with ?month(DateValue(Me.txtServicingWorkHoursEndDate) in the immediate window. thanks guys!!
update - it gives me the same problem for the start date. if i put the start date as anything before 1 dec to 11 dec it works fine.
start date 12 dec and end date 12 dec gives me records for 12 dec. when i change start date to 11 dec bham! i get records from 26 oct to 12 dec. so weird!!!! (compacting and repairing the database doesn't help as well!!)
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.