1. How do I convert a Text field that has records like '2002-07-17 21:39:08.392325' to a Datetime field in Access. (I really don't need the millisecond part and would not mind getting rid of that if possible)
2. I want to do a DateDiff between two date fields however, I want to "only" count times that fall within 6AM - 11PM. In other words, if the datetime on one field is '2002-10-28 22:59:00.000000' and '2002-10-29 06:02:00.000000' on the other, the result of a datediff would be 3 minutes.
Thank you so much for your help.