Start & End of Year

[psowerby]

I have a DateWkd field in my Database query and would like to
calculate the hours worked for this year from the 1st July 2006 to the
30th June 2007 if I filter for 2007 in the date field, and like wise
if I filter for 2006, the year would be 1st July 2005 to 30th June
2006

Thanks

Peter

 

[Guest]

What data is in the DateWkd field? If it is a true DateTime then just use --
Between 7/1/2006 AND 6/30/2007
as your criteria.

 

[John W. Vinson]

I have a DateWkd field in my Database query and would like to
calculate the hours worked for this year from the 1st July 2006 to the
30th June 2007 if I filter for 2007 in the date field, and like wise
if I filter for 2006, the year would be 1st July 2005 to 30th June
2006

Thanks

Peter
try:

= DateSerial([Enter fiscal year:] - 1, 7, 1) AND < DateSerial([Enter fiscal year:], 7, 1)

as a critterion.

John W. Vinson [MVP]

 

[psowerby]

I have a DateWkd field in my Database query and would like to
calculate the hours worked for this year from the 1st July 2006 to the
30th June 2007 if I filter for 2007 in the date field, and like wise
if I filter for 2006, the year would be 1st July 2005 to 30th June
2006

Thanks

Peter

try:

= DateSerial([Enter fiscal year:] - 1, 7, 1) AND < DateSerial([Enter fiscal year:], 7, 1)

as a critterion.

John W. Vinson [MVP]

thanks John, just what I wanted