Date comparison not working as expected

  • Profile Image
    stormingrobots
    Asked on January 24, 2017 at 12:43 AM

    Date comparison "Before" vs "After" backward.  

    in the conditional criteria ; I have the enrollment date field set to "Current" date.  I then have a criteria to  compare to

    this current date with "2017/03/01" . If the current date is less than that, i assign a particular value. However, it only shows the proper value if I do   "After" "2017/03/01"  . But the current date is "2017/01/24".  I will continue to see if it is because the format of the date was wrong!?

     https://www.jotform.com/70208611384148

  • Profile Image
    owen
    Answered on January 24, 2017 at 03:20 AM

    Hi,

    This is caused by another condition you setup for the field called "Early Registration". You pass $0.00 if the "Request a $10 6-month License." is equal to no and this overrides the condition related with the date field. Since it is set to no by default it does not change if the option is changed to yes. 

    I suggest you to select nothing by default:

    This should make the conditions work as expected. Please try this and let us know if the issue still persists. 

    Do contact us again if you need any further assistance. 

  • Profile Image
    stormingrobots
    Answered on January 24, 2017 at 09:28 AM

    Thank you!

    I did not catch that because the value shows up if I switched to "After" instead of "Before".  I wonder why changing to "After" will cause the amount to show up?

  • Profile Image
    Welvin
    Answered on January 24, 2017 at 11:25 AM

    That is because of the default value. I have removed the value for you and changed your conditional logic to "after".

    It's not empty by default: