Good morning all!
Not sure if it's because I had too long of a Christmas break or what, but I just can't seem to get my head around trying to write a date expression for the following:
I need to filter a query to give me everything for the previous year but only until Feb 15 of the current year.
Right now I have an expression that as soon as a new year starts everything in the previous years are excluded. What I really need is to still show all the previous years records until at least the 15th of February in the current year. I want this to change automatically ie: I don't want to hard code the dates into the query.
Example:
Todays date is Jan 6/2011 - I want to show all purchase orders for 2010 plus any that have been issued in 2011.
Todays date is Feb 16/2011 - I want to show only the purchase orders issued in 2011.
I hope that this makes sense.
Thanks
QTip