I have dates formatted as general date. Input mask in forms is 99/99/0000\ 00:00;0;_ When I try to query these dates using #02/18/2018# nothing results. If I use a between with the previous day and next day it will work. What am I doing incorrectly?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.