Start & End of Year

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
 
K

KARL DEWEY

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.
 
J

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]
 
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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top