Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count Of Days In Month.

Hi , Date                     hire date 05-Aug-2020       05-aug-19   I need how many months diffrence Date and hire date,please help on this issues.     Regards,
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , as new column

    datediff([hire date],today(),Month)

    or

    datediff([hire date],[date],Month)

     

    as a new measure // you need to take care of row context

    datediff(min([hire date]),today(),Month)

    or

    datediff(min([hire date]),Max([date]),Month)

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try new column

Column = DATEDIFF([hire date], [Date], MONTH)