Issue Report - DATEDIFF for Two custom fields | Community
Skip to main content
DebraRa
DebraRa
New Participant
August 28, 2024
Question

Issue Report - DATEDIFF for Two custom fields

  • August 28, 2024
  • 1 reply
  • 466 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

lgaertner
lgaertner
New Participant
August 29, 2024

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

    DebraRa
    DebraRaAuthor
    New Participant
    August 29, 2024

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...