Feb 19, 2014 #1 itguymike Technical User May 27, 2005 28 US i want to show only Purchase orders for last year and am drawing a blank on it. {PURCHASE_ORDER.ORDER_DATE}= year (2013) then says it wants a date
i want to show only Purchase orders for last year and am drawing a blank on it. {PURCHASE_ORDER.ORDER_DATE}= year (2013) then says it wants a date
Feb 19, 2014 #2 AndyMc Vendor Mar 17, 2001 333 US year({PURCHASE_ORDER.ORDER_DATE}) = 2013 Upvote 0 Downvote
Feb 19, 2014 Thread starter #3 itguymike Technical User May 27, 2005 28 US oh geeze, thank you Upvote 0 Downvote
Feb 19, 2014 #4 PeterDimitrov IS-IT--Management Dec 21, 2012 176 US {PURCHASE_ORDER.ORDER_DATE}= Year(DateAdd("y",-1,CurrentDate)) http://www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards. Upvote 0 Downvote
{PURCHASE_ORDER.ORDER_DATE}= Year(DateAdd("y",-1,CurrentDate)) http://www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.