Really hoping for some help here. I have a formula that I cant workout how to write in Crystal. In my report I currently have this written in a text field hoping that when the report exports to excel it will read that it is a formula and then automatically calculate. Wishful thinking but it didn't work.

 

Please can somebody take a look and see if you can provide me the Crystal Formula so that I can use it in my report;

 

=IF(DATE(YEAR(TODAY()),MONTH(C3),DAY(C3)) < TODAY(),DATE(YEAR(TODAY())+1,MONTH(C3),DAY(C3)),DATE(YEAR(TODAY()),MONTH(C3),DAY(C3)))

 

My date field in Crystal will obviously be where (C3) features in the above formula.

 

Thanks