EXporting to EXcel 1

[BJTIMSON]

Created a report which works fine in Crystal 10 but when I try & Export to Excel , I am taken back into the Crystal Formula Editor with a message "The Number of Days is Out of Range". The Excel file is not created. The formula it highlights is
TOTEXT(CURRENTDATE+(({MITBAL.MBPFTM}/5)*7)+10)

 

[GJParker]

change the formula to use the DateAdd() function

ToText(DateAdd("d",(({MITBAL.MBPFTM}/5)*7)+10,CurrentDate))

HTH

Gary Parker
MIS Data Analyst
Manchester, England