year from mars to mars

[phpatrick]

what is the selectcriteria to say on a date field I need the datums from 1 april until end mars of the year after this.

In most cases you ask the data of a certain year. Thats easy, you can use the format function.

But here the year is from 1/04/2006 until 31/03/2007.
I need to tell this to my query

 

[SkipVought]

Hi,

Try this...

Where [dtField] Between DateSerial(Year(Date) - 1, Month(Date), 1) And  DateSerial(Year(Date), Month(Date), 0))

Skip,
[sub]
[red][/red]
[/sub]

 

[PHV]

In the criteria cell of your date field:
Between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date()),3,31)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886