How to replace values in bulk.
I want to change the "2021", but i have to key in manually every single #datetime().. What function do I implemented if I want to change all the "2021" to "2022" in a single function? Below is the query for reference.
if [Created] > #datetime(2021,8,31,0,0,0) and ([Project Status] = "A" or [Project Status] = "B")
then "CYP"
else if ([Created] < #datetime(2021,8,31,0,0,0) and [Project Status] <> "C")
then "PYIPP"
else if ([PAD] < #datetime(2021,8,31,0,0,0) and [Project Status] = "C" and ([Submission] = "Closed" or [Submission] = "Approved") )
then "PYP"
else if ([Created] < #datetime(2021,8,31,0,0,0) and [PAD] > #datetime(2021,8,31,0,0,0) and [Project Status] = "C" and ([Submission] = "Closed" or [Submission] = "Approved") and [Project Saving] < 50)
then "PYmP"
else if ([Created] < #datetime(2021,8,31,0,0,0)and [PAD] > #datetime(2021,8,31,0,0,0) and [Project Status] = "C" and ([Submission] = "Closed" or [Submission] = "Approved") and [Project Saving] > 50)
then "Past Year Major Project"
else if ([Created] > #datetime(2021,8,31,0,0,0) and [Project Status] = "C" and ([Submission] = "Closed" or [Submission] = "Approved") and [Project Saving] < 50) then "CYmP"
else if ([Created] > #datetime(2021,8,31,0,0,0)and [Project Status] = "C" and ([Submission] = "Closed" or [Submission] = "Approved") and [Project Saving] > 50)
then "CYMP"
else "Please review"