I want to find the difference between dates along with the months. Example Date1 is 2032-01-15 and Date 2 is 2021-02-22 the expected difference is 10years and 11 months so it should appear as 10.11. Using Year(Date1) or Month(Date1) is not giving expected answers. Any help on this?
It depends on your data structure. Do you mean you have 2 fields and you want to find the difference or that you want the difference between one date and another in the same field. If you also post your app, it will be easier to answer.