Forum Discussion
Solved
Multi-Record Calculation Issue
Hello- I have a calculation for obtaining hours from the past 12 months based on the effective date of an action. I am running into an issue when there are multiple actions that have occurred in the...
Thank you GeraldGEmerick Looks like using EDATE fixed the issue 🙂
TCatron18 You are using DATEDIFF incorrectly here. DATEDIFF calculates the difference between two dates, it does not return an actual date value. But, because a date is technically a number, you aren't getting an error. Try using EOMONTH instead of DATEDIFF to return an actual date.
Thank you GeraldGEmerick Looks like using EDATE fixed the issue 🙂