Calculating number of months between dates

Need help
1

Currently trying to calculate the number of months between 2 dates.

As i understand this can be done using “exctract” function. so i need to

  1. Current date, extract year - start date, extract year *12
    • Curreent date, extract months - start month, extract month

for some reason this simply isn’t working for me. So i have simplified it to just the year part for now to try and get a correct result, see screenshot attached. The result this is giving me in me is
24264 which is basically todays date 2022 x 12. so its like its skipping the part in between.

Any help appreciated

image

2

This topic was automatically closed after 70 days. New replies are no longer allowed.