Date math outputting number as text?

[Kemidan2014]

I have 2 Query expressions to output a value to show how many days something is late or left until due.
When I run the query the DaysPlanOD number values are on the right side of their field
but DAYSActOD values are all on left side of the field.
Neither of these are fields in any tables just a math expression in the query itself.

I confirmed all fields involved are "Date/Time" structured but when I export the query to Excel DaysPlanOD is a Number but DaysActOD is NOT a number and this is the value I wanted to graph. Why would this be? I know I can manually go in and convert it to a number but the idea was to be hands free for the user so what do I need to change to get DaysActOD to be a number?

DaysPlanOD: IIf([ltcmPlanSubmitted] Is Null,Date()-[LTCMPlanDue],[LTCMPlanSubmitted]-[LTCMPlanDue])

DaysActOD: IIf([OriginalLTCMActualDueDate] Is Null,"",IIf([LTCMActualSubmitted] Is Null,Date()-[OriginalLTCMActualDueDate],[LTCMActualSubmitted]-[OriginalLTCMActualDueDate]))

 

[Joe4]

I think it is because your "DaysActOD" field can return "", which is considered a text value.
Try returning 0 instead, i.e.

DaysActOD: IIf([OriginalLTCMActualDueDate] Is Null,0,IIf([LTCMActualSubmitted] Is Null,Date()-[OriginalLTCMActualDueDate],[LTCMActualSubmitted]-[OriginalLTCMActualDueDate]))

 

[Kemidan2014]

That did the trick thank you very much!

 

[Joe4]

You are welcome.
Glad I was able to help!