Date filter problem

[LLB]

I have a report that I need to filter. The report data comes from a query. The date field I need to filter is formated mmm-yy. In my report I want to only show records only from the current year and subsequent years, not previous years.

Most of the examples I've seen in my search seem to filter the year by exatly 365 days but that's not what I want.

I tried adding a field to the query to change the format to "yyyy" but couldn't get a criteria to work.

Still a struggling newbie.

 

[LLB]

I got it to work the way I want by putting this criteria into the query field: >=#1/1/04# Or Is Null But I don't want to have to go in there every year and change it to the current year. Is there a way to say the same thing only using the "current year" as opposed to "2004"?

Looking forward to a response.

Thanks

 

[DES]

Database problems

Nice to meet somebody else from Ontario.

Sounds to me like you need some sort of variant using the format(now(),"yyyy") or something of the like.

If you would like some feedback or for me to have a look at what you have drop me a line. I have time to kill.