Start & End of Year

  • Thread starter Thread starter psowerby
  • Start date Start date
P

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
 
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.
 
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)
Click to expand...

as a critterion.

John W. Vinson [MVP]
 
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
Click to expand...
Peter
Click to expand...

try:

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

as a critterion.

John W. Vinson [MVP]
Click to expand...

thanks John, just what I wanted
 
Back
Top