Date formula not working access 2010 (1 Viewer)

[guinness]

Hi All

I'm possibly missing something obvious here but a date formaula that I was using in access 2007 doesn't seem to be working in 2010.

The formula that I had was Between DateSerial(Year(Date())-IIf(Month(Date())<4,1,0),4,1) And DateSerial(Year(Date())+IIf(Month(Date())>3,1,0),3,31). The calculation allowed me to count holiday hours taken between 1st April and 31st March. The problem is that it was working up till 31st march but is not now showing holidays taken since 1st April.

Any ideas?

 

[Isskint]

What are you getting from it that tells you it is not working? Error message, a value you did not expect??

Bare in mind, this formula will now be looking at entries between 01/01/2014 and 31/03/2015. If no holidays have been taken you will get 0 results

 

[guinness]

Thanks for the reply.

I think I might have worked it out though. Users input their hours each week using the week commencing (w/c) date. I'm forgetting that although people have taken holidays last week they will all be reporting as being taken W/C 31st March (i.e last year).

Just not awake enough for a Monday morning

Thanks again

Kev