IFS Command change of month

[Childr01]

hello, i have an auto generating monthly database with set commands. i am moving from March to April and can not figure out why the Code will not update when i change months... please can someone help?
i have tried changing Mar to Apr...

=IFS(AND(Mar[@[Date Due]]=0,Mar[@[Date Closed ]]=0),"",AND(Mar[@[Date Closed ]]=0,Mar[@[Date Due]]>=TODAY()),"Ongoing",AND(Mar[@[Date Closed ]]=0,Mar[@[Date Due]]<TODAY()),"Overdue",Mar[@[Date Closed ]]>Mar[@[Date Due]],"Penalty",Mar[@[Date Closed ]]<Mar[@[Date Due]],"Completed",Mar[@[Date Closed ]]=Mar[@[Date Due]],"Completed")

Thank you

 

[RoryA]

i have an auto generating monthly database

What exactly does that involve? Unless you are changing the table name, the formula you have should not change.

 

[Childr01]

This is a log of actions/ Jobs which are dated to check completion. currently set up on separate tabs for months to be able to collate for outstanding actions. the code above has "Mar" which i assume is for March but now i am in April, the code displays all actions as overdue. i can only assume that changing the code to Apr rather than Mar should resolve this?