Sorting Date Formats

[Wrinkles]

I based a query on a date field that I formatted to "mmm,yyyy". When I enter a search date range from eg July,2004 to Sept, 2004 it returns all months starting with "J" to "S" rather than the calendar months. I know that the format function does return a string but how can I change this so that when a user types a month range it will return the proper calendar months?

 

[ecniv]

Have the actual date field as the filter with the users input...

eg

"...Where datefield = #" & <dateselected> & "# ..."

Or use the function Month around the date field, somewhat like the above example.

Read the help files on the Month function.


Vince

 

[Wrinkles]

Date Formats

Thanks have looked at this but I think I might in hindsight keep the date in dd/mm/yyyy format for ease of entry.