Dear SF Compensation Experts,
In my template, we do have a requirement to do date difference between employee hire date and End Date (a constant date value). Hire date is taken from EC field ID: startDate.
When tried direct dateDiff between startDate and EndDate, the values appear as N/A. dateDiff(startDate,cust_ENDDATE).
formula: dateDiff(toDate(startDate,"MM/dd/yyyy"),toDate(cust_ENDDATE,"MM/dd/yyyy"))
Then, i created a custom column of type String and displayed startDate as toDate(startDate,"MM/dd/yyyy"). This logic also failed as it shows N/A.
Also, the dateDiff(toDate(CUST_HIREDATE,"MM/dd/yyyy"),toDate(cust_ENDDATE,"MM/dd/yyyy"))
Can someone advise on how this to be corrected where the CUST_HIREDATE should display hire date in MM/DD/YYYY, also the cust_ENDDATE is already in MM/DD/YYYY format?