Jan 29, 2008 #1 aaviles769 IS-IT--Management Joined Jan 29, 2008 Messages 4 Location US I am trying to get data for the last 3 weeks and cannot seem to find a default formula for it. MonthtoDate is too far back
I am trying to get data for the last 3 weeks and cannot seem to find a default formula for it. MonthtoDate is too far back
Jan 29, 2008 #2 CoSpringsGuy IS-IT--Management Joined Aug 9, 2007 Messages 955 Location US If you are looking for exactly 3 weeks for today use {datefield} >= currentdate-21 _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection Upvote 0 Downvote
If you are looking for exactly 3 weeks for today use {datefield} >= currentdate-21 _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection
Jan 29, 2008 Thread starter #3 aaviles769 IS-IT--Management Joined Jan 29, 2008 Messages 4 Location US Awesome, great. Upvote 0 Downvote