2 of 2 people found this helpful
You can use either 1 for true or the word "true".
I just use 1.
You don't really need to update the ex-clients to "0".
But when you use filters for reports etc, you should use Client is TRUE or Client IS NOT True.
I wouldn't really use Client IS false to target ex-clients.
Thank you for your response.
1 of 1 people found this helpful
You might think about storing this data differently.
It might make more sense to store the data as a pick list.
Customer Type: (Choice)
Good point - thank you for your response.