Scripting to report a rolling 3-month average

[judlin]

I'm having trouble scripting a find for a 3-month rolling time period.  I need to find a date range starting from 3 months prior to yesterday through yesterday.  I can't seem to get my head around the calculation for that range.  Can anyone help please?  Thanks.

[jbante]

Try using this calculation to build your search criterion on your date field, and let us know how it goes:

 

Let ( [
~yesterday = Get ( CurrentDate ) - 1 ;
~threeMonthsAgo = Date ( Month ( ~yesterday ) - 3 ; Day ( ~yesterday ) ; Year ( ~yesterday ) )
] ;
~threeMonthsAgo & "..." & ~yesterday
)