Filter data by date time in MS access, Select only date without selecting time from date time field in MS Access

Select * from TransactionInfo where CDate(Int([CreatedDate])) between #2010-05-04# and #2010-05-05#
—————–
it will return date like
—————–

23-May-2010

Select * from TransactionInfo where [CreatedDate] between #2010-05-04# and #2010-05-05#

—————–
it will return
—————–

Continue reading