Forum Discussion
Conditional replacing of dates
Hello, I am trying to replace dates in column "BASELINE Start Date" with a date of 1 Jan 2000 based on if the value in column "RAG Number" = 4. See querry below. It is not working somehow... Any...
Perhaps your [RAG Number] column is number type, not text type?
Try changing this:
each if [RAG Number] = "4" >> each if [RAG Number] = 4 // No quotes for number typesPete
Thanks for the feedback. I have tried, but unfortunatly no luck.
Perhaps your [RAG Number] column is number type, not text type?
Try changing this:
each if [RAG Number] = "4" >> each if [RAG Number] = 4 // No quotes for number types
Pete
Hi BA_Pete,
Great! This indeed solved the problem. Many thanks!