Plan Vs Actuals in Transformer model

[rpvs]

Our plan data is monthly and actuals are daily. In powerplay transformer (Ver 7.3.1)  , have renamed the month column which is an integer to date same as the column name date for the actuals.  For the integer column date (month) in Plan , changed the data class to date and left date input format to predefined as there is no option just for the month.

The plan numbers in the analysis we are getting is not correct for the month and are getting all the plan data we have currently which is for one year.

What am i doing wrong??? Why is there no option in the date input format for Month??

Please help!!!