S SEALEGGS New member Local time Today, 03:34 Joined Apr 4, 2014 Messages 4 Apr 4, 2014 #1 What is the best way to pull all records in a rolling 365 day period. Like from 4/3/2013 to 4/4/2014?
What is the best way to pull all records in a rolling 365 day period. Like from 4/3/2013 to 4/4/2014?
P plog Banishment Pending Local time Today, 05:34 Joined May 11, 2011 Messages 12,060 Apr 4, 2014 #2 Really depends on the date to start rolling. Assuming its always to be today looking backwards this would work in the criteria section of the Date field you are using >=(Date()-365) AND <=Date()
Really depends on the date to start rolling. Assuming its always to be today looking backwards this would work in the criteria section of the Date field you are using >=(Date()-365) AND <=Date()
N namliam The Mailman - AWF VIP Local time Today, 12:34 Joined Aug 11, 2003 Messages 11,685 Apr 5, 2014 #3 dateadd("Y", date(), -1)
