How to take year and month

[sunil-kumar5]

Hi All,

I have a table containing license installation information, so I have columns like Name, License Number, Address, Installation Date, Due Date. Now on the basis of these columns I have to identify how many license renewed every month.

Note: All license renewed after 12 months and one month is extension so its 13 months.

I used condition in my load script like:

If(DueDate<Today(),'Expired',
If(AddMonths(InstallationDate,13)<DueDate,'Renew','Active')) as RenewStatus,

This formula giving me the Renew count to some extent correctly but when I select year from installation date or Due date it does not give me the correct records. It shows many records having renew data which is under 12 months not 13 months.

Please advise as I believe it must be a year and month selection issue but not sure how to correct it.

Thanks

[PradeepK]

Best Guess.. As per provided data.. Maybe there is some issue with if() comparison. Make sure your fields are of date time. 

Please add more details.. like what year field and how it is derived from InstallationDate and connected in Model.