Want to subtract two dates for absence leaves — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Want to subtract two dates for absence leaves

edited Aug 9, 2020 11:26PM in Reporting and Analytics for HCM 2 comments

Summary

Hi all, I am trying to create a column with the total days in an absence.

Content

I am trying to subtract the start and end dates of the leave to create that information however, it is not working for some reason. The start date of the leave and the end date are both in separate columns, and I want to subtract the values in them. I am wondering if I have to create the dates as all numerical to aid the calculations? I am trying this formula: min(start date) MINUS max(end date) however it is coming up as an error. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!