I am trying to display a based on some arithmetic. The formula I am using is this


if {Table.Field} = "A"
then
"See Notes"
else
if
{Table.Field} = "B"
then
totext(({Table.DateTime} +2)-today, "dd-MMM-yyyy")
else if
{Table.Field} = "C"
then
totext(({Table.DateTime} +9)-today, "dd-MMM-yyyy")
else if
{Table.Field} = "D"
then
totext(({Table.DateTime} +119)-today, dd-MMM-yyyy")


When I create the formula I am told there are no errors.
When I add the formula to the report and refresh I get an error saying

"Bad Number Format String"

My end result would be to show a date something expires based on the math.

So yes the formula you provided will return a number, but not a date. I need a calendar date. Because of the one special case where the output of the formula will be a text string is throwing off the whole works

Edited by bremen - 13 Jan 2015 at 6:26am

It is for a count down. It displays a "Days Remaining" Number. The formula to produce the number is working fine. I need a separate formula to produce a calendar date.