prompt for between dates in a query

[LaughingBull]

Query Date Field
Between [Enter Beginning Date] And [Enter End Date]

Run and enter 07/01/2014 and 06/30/2015
The return one record dated 07/01/2014

Run again enter 07/01/2014 and 12/31/2014
Return all records between those dates.

when I put in dates for 2014 to 2015 it does not return all records between those dates only the records for the beginning date, is there something I am missing asking for records from one year to another?

[pbaldy]

check the data type of your field; it sounds like it may be text rather than date/time.

[LaughingBull]

That was it Thanks

[pbaldy]

No problemo.