?
Solved

Convert days to months

Posted on 2002-05-16
10
Medium Priority
?
1,976 Views
Last Modified: 2011-04-14
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
Comment
Question by:nmilmine
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 14

Accepted Solution

by:
mgrattan earned 200 total points
ID: 7015047
Use the DateDiff function:

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

Expert Comment

by:nico5038
ID: 7015049
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
 

Expert Comment

by:senan072100
ID: 7015050
the result of substracting to date variables is number, so what about dividing it by 30 !!!
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 54

Expert Comment

by:nico5038
ID: 7015052
Just typed too much too slow.... ;-(

Hi mgrattan ;-) !

Nic;o)
0
 
LVL 4

Author Comment

by:nmilmine
ID: 7015124
Thanks

Neil
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 7015145
You're welcome nmilmine.

Hi Nico!

Mike.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7015161
(off record, sorry Neil)

Mike,

Missed your comments for a while !

Nic;o)
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 7015175
<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
 

Expert Comment

by:senan072100
ID: 7015695
Magrattan,, thanks,,, useful function.
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 7016503
You're quite welcome....

Mike.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question