Question:
Why is the data format being regarded as month/day instead of day/month in a Query’s filter by date when the day is a number lower than 13?
Solution:
This happens because the database’s data type is set up as string, and CDate command does not convert this value properly.
To fix this, the data type must be set up as double.
