x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 1987

# Convert days to months

Hi Everyone

I have a formula that calculated the no of days between 2 dates.

What I want to do is convert the no of days into complete months

Thanks
Neil
0
nmilmine
• 4
• 3
• 2
• +1
1 Solution

Commented:
Use the DateDiff function:

datediff("m",<date1>,<date2>)
0

Commented:
Hi Neil,

Just checkout the date/time routines at: www.mvps.org/access

BTW complete months from days will differ depending on a startdate. e.g. before and after the 28th of februari...
so Datediff("m",..) could do the trick for you.

Nic;o)
0

Commented:
the result of substracting to date variables is number, so what about dividing it by 30 !!!
0

Commented:
Just typed too much too slow.... ;-(

Hi mgrattan ;-) !

Nic;o)
0

Author Commented:
Thanks

Neil
0

Commented:
You're welcome nmilmine.

Hi Nico!

Mike.
0

Commented:
(off record, sorry Neil)

Mike,

Nic;o)
0

Commented:
<Off topic again>

Hi Nico;

I've been poking my head into EE now and then but I'm so busy at work with Access, Excel VBA, and Essbase projects that I hardly have any time to visit.

Looks like you've been spending quite a bit of time here though!  If you like, email me at outuvtime at yahoo dot com.

Mike.
0

Commented:
Magrattan,, thanks,,, useful function.
0

Commented:
You're quite welcome....

Mike.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Featured Post

• 4
• 3
• 2
• +1
Tackle projects and never again get stuck behind a technical roadblock.