Query

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I have a form where I am pulling data from a query. In the query, I have
a datedif function that is showing all day accumilated based on certain
factors. I want the dates to show only for the current year. not all years.
here is what I have ...


Days accured: DateDiff("d",[hDate],Date())

So if the start date is in the year 2001 I am totalling days all the way
back to then. How can I have this show only dates in the current year,
2003???
 
I'm not sure if I understand you correclty but why not
make a new column in your query that gets the year value
and put a criteria on that column of 2003:
GetCurrentYear: Format("yyyy",[hDate])
criteria=Format("yyyy",Date())

-Cameron Sutherland
 
Back
Top