Forum Discussion

miguelflores's avatar
miguelflores
Icon for Advocate I rankAdvocate I
9 years ago
Solved

How to get month in a date

Hi!   I'm encountering a road block, how do i get the month in a date data type? I have a column date hired and regularization date. I want to compute for the 5, 3 and 1 month remaining before reg...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Please try this

     

    Months Between = IFERROR(DATEDIFF(
     [date_hired],
     [regularization_date],
     MONTH
     ),-1)
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Please try this

 

Months Between = IFERROR(DATEDIFF(
 [date_hired],
 [regularization_date],
 MONTH
 ),-1)
miguelflores's avatar
miguelflores
Icon for Advocate I rankAdvocate I
9 years ago

Thanks Phil! I got it! haha