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
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