Issue Report - DATEDIFF for Two custom fields | Adobe Higher Education
Skip to main content
DebraRa
DebraRa
Level 2
August 28, 2024
질문

Issue Report - DATEDIFF for Two custom fields

  • August 28, 2024
  • 2 답변들
  • 491 조회

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

이 주제는 답변이 닫혔습니다.

2 답변

lgaertner
lgaertner
Level 9
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
    DebraRa작성자
    Level 2
    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.

    약관 및 조건Accessibility statement

    Loading footer...