DATA Step, Macro, Functions and more

Difference between Two dates (months)

Accepted Solution Solved
Reply
Contributor
Posts: 43
Accepted Solution

Difference between Two dates (months)

Hello, how can I obtain difference between two dates in months, example:

 

DATE1             DATE2                RESULT

01MAY2013     01AUG2013        3

01JAN2010      01DEC2010        11


Accepted Solutions
Solution
‎02-03-2017 04:27 PM
Super User
Posts: 19,851

Re: Difference between Two dates (months)

Posted in reply to Angel_Saenz

All Replies
Solution
‎02-03-2017 04:27 PM
Super User
Posts: 19,851

Re: Difference between Two dates (months)

Posted in reply to Angel_Saenz

INTCK()

Contributor
Posts: 43

Re: Difference between Two dates (months)

Reeza, you could be more specific like:
INTCK('month',DATE1,DATE2);
But I think you are trying to make me research, jaja just kidding, thank you for your help Smiley Happy
Super User
Posts: 19,851

Re: Difference between Two dates (months)

Posted in reply to Angel_Saenz

Angel_Saenz wrote:


But I think you are trying to make me research, jaja just kidding, thank you for your help Smiley Happy

 

Pretty much. Learn how to navigate the functions...it's faster than asking questions and waiting for a response. I still look them up on a regular basis. I don't know the answers to all these questions, but I know where to find the answer.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 247 views
  • 2 likes
  • 2 in conversation