Date criteria in a query or report

[finrsteve]

Please help, I'm trying to query a list of dates with only 09/01/xx - 09/30/xx. Doesn't that require writing an expression in the criteria field?? If so, what?

[PEB]

In fact in the Critera you have to type:

Between Cvdate("01/09/2006") AND Cvdate("30/09/2006")

[finrsteve]

In fact in the Critera you have to type:

Between Cvdate("01/09/2006") AND Cvdate("30/09/2006")

Thank you PEB, is it possible to retrieve all sept. dates no matter what year (i.e. 9/4/02,09/06/05,09/01/03 ??)

[PEB]

Yes You can do the follow:

In your query column containing your Date you type:

My_formated_date:Format([your Date];"dd/mm/yyyy")
In the criteria you type Like "09/*"

And you obtain all dates that begin with 09!

Does this help you? :)

[PEB]

If you use an expression like Format([My_date],"dd/mm/yyyy") Firstly is your day

So you have to change the epression to "mm/dd/yyyy" ;)

[finrsteve]

If you use an expression like Format([My_date],"dd/mm/yyyy") Firstly is your day

So you have to change the epression to "mm/dd/yyyy" ;)

You got me confused with post #4, where do I type : My_formatted_date.......??

[PEB]

Ok!
This expression you have to put in the first row, not matter which column in your query gird

The olace you usually put the field Names

Instaed a field Name

Just where it is wrote in left Field! :)