I am trying to set up a predictive date sort - so certain scenarios have different due dates.

I've set up a formula field as follows:

if isnull({@ApptDate})
    then if isnull({@ScheduledDate})
        then if isnull({order_.apptTimeframe})
            then cdate(dateadd("d",14,{@OrderedDate}))
        else {@FinalTimeFrame}
    else cdate(dateadd("d",14,{@ScheduledDate}))
else cdate(dateadd("d",7,{@ApptDate}))

It is returning all of the correct dates for the scenarios, except for @ScheduledDate, which comes back null. At first I thought maybe there was something wrong with @ScheduledDate, but it is formatted exactly like @ApptDate which does return correctly. On these records, @ApptDate and order_.apptTimeframe are both null.

Any ideas for why it would be blank? You would be my hero.

It is:

if isnumeric({order_.scheduledDate})
then date(tonumber(left({order_.scheduledDate},4)),tonumber(mid({order_.scheduledDate},5,2)),tonumber(right({order_.scheduledDate},2)))

And it does display on the same record returned by the report

I have to convert all of the dates to dates because in the database they are actually string fields (It's an electronic health record). I am going to play around and if I figure out where the problem is, I'll post my solution here. Thanks for your help!

inside the formula editor try changing the option for how to handle NULLS to 'use default values for nulls'