Skip to main content

Good day to all:

 

I created a calculated field for the last 3 months

 

if [Date Shipped] >= (DATEADD('month', -3, today())) and [Date Shipped] <= (DATEADD('month', 0, today())) then [Freight Charges] END

 

How could I modify this formula to calculate same period a year before?

 

Any suggestions

 

Much appreciated!

2 answers
0/9000