Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1984
  • Last Modified:

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
Asked:
nmilmine
  • 4
  • 3
  • 2
  • +1
1 Solution
 
mgrattanCommented:
Use the DateDiff function:

datediff("m",<date1>,<date2>)
0
 
nico5038Commented:
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
 
senan072100Commented:
the result of substracting to date variables is number, so what about dividing it by 30 !!!
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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

Hi mgrattan ;-) !

Nic;o)
0
 
nmilmineAuthor Commented:
Thanks

Neil
0
 
mgrattanCommented:
You're welcome nmilmine.

Hi Nico!

Mike.
0
 
nico5038Commented:
(off record, sorry Neil)

Mike,

Missed your comments for a while !

Nic;o)
0
 
mgrattanCommented:
<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
 
senan072100Commented:
Magrattan,, thanks,,, useful function.
0
 
mgrattanCommented:
You're quite welcome....

Mike.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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