Skip to Content
0
Sep 12, 2023 at 06:39 AM

ToDate and DateDiff formulae not working in SF Compensation

200 Views Last edit Sep 12, 2023 at 07:10 AM 2 rev

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?