What Date Picker Field is Used in this Example?

  • Profile Image
    thebells14
    Asked on February 24, 2020 at 09:21 AM

    What Date Picker Field is used in this link?  It's number 5 [date()] under Other Functions here:

    https://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference

    It says to use the "default date picker field", so which is this?

    I'm trying to compare a user entered date to second user entered date on a form to make sure that one is at least 7 days after another and I can't seem to find the correct date picker to use in a calculation as my calculation does not yield a result other than ZERO.

    Thank you

  • Profile Image
    BJoanna
    Answered on February 24, 2020 at 11:54 AM

    It is a basic Date Picker field.

    1582563049date.PNG

    If you are unable to perform a calculation in your form, provide us a form URL and tell us what exactly are you trying to achieve.

    Where to Find My Form URL?

  • Profile Image
    thebells14
    Answered on February 24, 2020 at 02:15 PM

    Thank you.

    Yes, I am struggling with the date picker after all.  I thought I had the wrong date picker, but now I don't think so. 

    Here is my form URL:

    https://form.jotform.com/200195201922949

    I'd like the form to show the red text under the "Date the Last Contingency Period Ends" if the De-stage By Date right below it is less than 7 days after the Last Contingency date.  If not, it can hide that text.

    I have a similar arrangement working for the Destage by Date, but it is pulling from Today's Date that I was able to get converted to numbers behind the scenes, unlike the Last Contingency Date which is user entered.

  • Profile Image
    VincentJay
    Answered on February 24, 2020 at 04:44 PM

    You can add a Text to your form and use the Show or Hide Condition based on the user's answer (Date). Here's a guide: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    Please try it and let us know if you need further help.

  • Profile Image
    thebells14
    Answered on February 24, 2020 at 04:49 PM

    Yes, I know.  Unfortunately that does not address my question.  I need to be able to convert the form user's date entry into a number and add 7 days to it.  Then, show or not show text based on the results.

    How do you convert a date entered by the form user into numbers and add 7 days to it?

  • Profile Image
    jherwin
    Answered on February 24, 2020 at 07:20 PM

    Can you please confirm if you're trying to get the number of days from the "current date" up to "The Date the Last Contingency Period Ends"?

    If so, you can do it like this (please see screenshot below):
    1582590014get days.png
    Here's the demo form: https://form.jotform.com/200547777611054

    Please give it a try and let us know if that could work for your needs.

  • Profile Image
    thebells14
    Answered on February 25, 2020 at 05:34 PM

    ok, I think I figured it out.  Thank you for your help.