Forum Discussion
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,
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)
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)