EPM 11.1.2.4 : Hyperion Planning : date function

@CalcMgrGetMonth

hello all,

i had worked in cloud and used function @CalcMgrGetMonth & @CalcMgrGetYear to extract year and month from member "Hire_date",

when i do the same in on-premise environment , it does not worked

The integer value '"Hire_date"' entered for argument in function : '@CalcMgrGetMonth("Hire_date")' is invalid.

then i used  following function,

"Month_flag"=@DATEPART("Hire_date",DP_MONTH);

"Year_flag"=@DATEPART("Hire_date",DP_YEAR);

but it gives me unexpected value. PFA