How to replace values in bulk.

JonathanNTH 1 Reputation point
2022-11-09T08:36:26.95+00:00

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"

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,103 questions
0 comments No comments
{count} votes