Joined: 25 May 2015
Online Status: Offline
Posts: 3
Topic: Automatic Pull Based on three months Posted: 06 Aug 2015 at 7:40am
This might be a ridiculous question, but I want to create a report that will automatically pull for the past three months from the print date. After I have the data, it will be calculated in a cross tab, so suppressing the records will not work. The date itself comes from a field named bc_dte. Thanks for any type of assistance.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 06 Aug 2015 at 8:31am
your select criteria can either do a calculation to determine the two dates in question or simpler approach may be to just use a datediff
e.g.
datediff('m', table.bc_dte, currentdate) in 1 to 3
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