Solved

Need formula to count months of service

Posted on 2009-03-31
5
267 Views
Last Modified: 2012-05-06
CRV10 - I need a formula that will give me months of service for each employee (as opposed to years of service). For example, if someone's hire date is 3/31/2004 then months of service would be 60, or if hire date was 1/5/2009 then months of service would be 3.  Thanks!
0
Comment
Question by:jph826
  • 2
  • 2
5 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 24030076
Please define how you are counting months of service, because based on your example it is not clear.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 24030088
Crystal has a DATEDIFF function you can use

DateDiff('m',{HireDateField},CurrentDate)

mlmcc
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 24030152
mlmcc,

Right, but check the examples provided.  DateDiff would return 60 for the former, and 2 for the latter.  The question
lists 60 (OK) and 3 (difference).

Regards,

Patrick
0
 

Author Comment

by:jph826
ID: 24030606
matthewspatrick - Sorry, you are correct, 3 should have been 2.

mlmcc - Thanks!  Exactly what I needed.
0
 

Author Closing Comment

by:jph826
ID: 31564881
Thanks again mlmcc!  I can always count on your answers to be right on - you have never steered me wrong.  Money well spent.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now