You need to sign in to do that
Don't have an account?
pauldes1
Calculate number of months between 2 dates
Is this possible? Trying to subtract the smaller date from the larger date, then divide by 30 to get the approximate number of months between 2 dates. Can't figure out how to convert the date value to an integer to do this....or is there another way completely?
Just in case anyone is searching for a solution, this works for me
(Year( CloseDate ) * 12 + Month(CloseDate)) - (Year( TODAY() ) * 12 + Month( TODAY() ))
HI Stefan
if i am giving Close date is 5/31/2012 and suppose today date is 6/01/2012 then it is giving 1months.Here Actually the differance is only one day but it is giving 1months
would you please right Round function and send to me.
Thanks
JD123.
I doubt you will get an answer tagging your question on to a very old post!
Suggest you start a new post!
If you just want the number of days then something like Today - CloseDate