I've been using this calculation for years with V6 and earlier versions:
If(terms = "First of Month" , DateToText( Date(Month(Invoice Date) + 1,Day("1"),Year(Invoice Date))) ,If(terms = "Upon Receipt", Invoice Date ,If( terms = "30 Day", Invoice Date + 30, DateToText( Date(Month(Invoice Date) ,Day("15"),Year(Invoice Date))))))
When I converted to 8.5 the calculation changed to:
If(terms = "First of Month" ; GetAsText( Date(Month(Invoice Date) + 1;Day("1");Year(Invoice Date))) ;If(terms = "Upon Receipt"; Invoice Date ;If( terms = "30 Day"; Invoice Date + 30; GetAsText( Date(Month(Invoice Date) ;Day("15");Year(Invoice Date))))))
It returns a value of "?" instead of a due date.
I've been fooling around for the last 4 hours trying to fix this.
Any ideas?