Joined: 10 Aug 2010
Location: United States
Online Status: Offline
Posts: 13
Topic: Last Months Data Formula Posted: 03 Jan 2011 at 12:30pm
I need some help with a formula I have been using to pull dates for the previous month.It has worked great all year until happy New Year.How do I edit this formula to take into account a change in year?My report for Dec 2010 that is being pulled in Jan 2011 turns up blank.
Month({Proccesor.Funding Dt}) = Month(DateAdd("m", -1, currentdate)) and year({Proccesor.Funding Dt}) =year(currentdate)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum