Date comparison not working as expected

  • 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

  • omerorkun JotForm Data Scientist
    Replied on January 24, 2017 at 3: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:

    Date comparison not working as expected Image 1 Screenshot 20

    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. 

  • stormingrobots
    Replied on January 24, 2017 at 9: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?

  • Welvin Support Team Lead
    Replied 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".

    Date comparison not working as expected Image 1 Screenshot 30

    It's not empty by default:

    Date comparison not working as expected Image 2 Screenshot 41