Setting Field based on multiple dates
hey all. This sounds basic but for some reason i cannot figure it out!
I am selling a product. Over the course of time, it has been upgraded (V1, V2, V3)
I created a field where i would like it to display the version number based on the order date.
So basically something like this:
If DATE > "10/1/14" set field (version) "V3"
If DATE > "6/1/14" but < "10/1/14" set field (version) "V2"
If DATE > "1/1/14" but < "6/1/14" set field (version) "V1"