D Dona Registered User. Local time Today, 23:10 Joined Jun 27, 2002 Messages 55 Mar 8, 2005 #1 How do you query date/time? I have a field with date and time, e.g. 4/2/2004 5:12:33 PM. I want to query all records before 4/2/2004. When I type < 4/2/2004*, I get an error message. Any suggestions? Thank you.
How do you query date/time? I have a field with date and time, e.g. 4/2/2004 5:12:33 PM. I want to query all records before 4/2/2004. When I type < 4/2/2004*, I get an error message. Any suggestions? Thank you.
KenHigg Registered User Local time Today, 18:10 Joined Jun 9, 2004 Messages 13,291 Mar 8, 2005 #2 < 4/2/2004 ??? Ken
D Dona Registered User. Local time Today, 23:10 Joined Jun 27, 2002 Messages 55 Mar 8, 2005 #3 THANKS KEN I thought I needed to put the * since I did not know the time. Guess not. Thanks! Have a great day!
THANKS KEN I thought I needed to put the * since I did not know the time. Guess not. Thanks! Have a great day!
KenHigg Registered User Local time Today, 18:10 Joined Jun 9, 2004 Messages 13,291 Mar 8, 2005 #4 Cool - You're welcome!