4 Replies Latest reply on Dec 14, 2014 1:00 AM by malibux14x

    Setting Field based on multiple  dates

    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?