RESHMA SURESH 2 Posted February 1, 2023 Share Posted February 1, 2023 How to calculate the difference between two dates in which one is date column and another is a date passed as a document property? Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted February 1, 2023 Share Posted February 1, 2023 An expression like:DateDiff([EndDate],DocumentProperty("DocPropName"))should work. Link to comment Share on other sites More sharing options...
Guest Posted February 2, 2023 Share Posted February 2, 2023 Use Datedi function as following.DATEDIF('19960302', '19970301', 'Y')pass the last parameter 'Y' for yearly difference, 'M' for monthly, D for daily, WD for weekdays and BD for business days. Link to comment Share on other sites More sharing options...
RESHMA SURESH 2 Posted February 2, 2023 Author Share Posted February 2, 2023 It didn't worked for me. Sorry Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted February 2, 2023 Share Posted February 2, 2023 Please provide more details. Are both the column and DocumentProperty of type Date? What happens/doesn't happen? Do you get an error message? If so, please provide the details. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now