AnsweredAssumed Answered

Setting Field based on multiple  dates

Question asked by malibux14x on Dec 12, 2014
Latest reply on Dec 14, 2014 by malibux14x

Title

Setting Field based on multiple  dates

Post

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"

Thoughts?

Outcomes