Hi All - I have tried a formula to work how how many days there are between two dates but keep failing. My data type for my dates data is a 'date' and in this format 2022-09-19.
Could someone kindly give me a formula to work out how many days are between these two dates please; 2022-09-19 and 2023-09-18 - Thank you in advance!
Solved! Go to Solution.
DateTimeDiff([Field1],[Field2],"days")
@binsell please use this formula
mark done if solved.
@binsell
workflow attached for reference
hope this helps.
You are on fire Raj! Thanks for always replying to my posts! :)