Issue Report - DATEDIFF for Two custom fields

[Ravara]

I'm trying to get the date difference between two custom date fields. I'm close but no cigar and I'm not see my error; code is below.

displayname=Days Missed by

linkedname=direct

querysort=entryDate

textmode=true

valueexpression=DATEDIFF({DE:dateActuallyMailed/Processed},{DE:dateSupposedToMail/Process})

valueformat=int

[lgaertner]

Hi Ravara,

your textmode is correct.

So, I would check,

- if you really defined both fields as Date Fields

and

- if both fields are filled with a value in any issue

Regards

Lars

[Ravara]

Thank you for validating my code I appreciate that.  I look and both custom fields are indeed date fields and most have data there are some that do not, but none are populating still. I may need to put in IT Ticket.