How to insert date (day/month/year) into date fields based on value from another field

  • Profile Image
    cris74
    Asked on April 13, 2016 at 07:06 PM

    How insert 14/04/2016 in date field, when another field is equal to "yes" ?



    This is a re-post of a comment on Conditional Logic Inserts Text/Calculation Into A Field

  • Profile Image
    Chriistian
    Answered on April 13, 2016 at 10:41 PM

    We can insert the date by getting the exact number of days from 1/1/1970 (the date computers use as a starting point) into the date that you want to use: 14/04/2016.

    I used the calculation from the time and date website to determine that there are 16,905 days between 1/1/1970 and 14/04/2016. Now we can use that information to populate the correct date into your Date field.

    Simply add the Update/Calculate condition below and use 16905 as the value in the calculate area.

    Here's a demo so you can see it in action: https://form.jotform.com/61038205730951.
    You can also clone it to your account to see the condition.

    If you need further assistance, please let us know.

     

     

  • Profile Image
    cris74
    Answered on April 14, 2016 at 08:45 AM
    Thank you for your reply, clear, precise and functional.
    However, I wish I could enter a date in the form day / month / year, which
    seems to me more explicit. I tried to date () as shown in the screenshot
    attached, but I do not get results, why? I misconfigured, or the syntax is
    it wrong? Could you enlighten me on this approach? On what topic can we
    find help? Thank you in advance.
    2016-04-14 4:39 GMT+02:00 JotForm :
    ...
  • Profile Image
    mert
    Answered on April 14, 2016 at 10:22 AM

    Hi there,

    If you want to use the date in the form dd/mm/yyyy, we can easily make it by changing the setting "Date Format" as "ddmmyyyy" for the "DateTime" field.

    Please, see the steps from the below:

     

    In addition, you don't need to change anything from my colleague's form, everything will work properly after the changes.


    Regards.

  • Profile Image
    cris74
    Answered on April 14, 2016 at 12:45 PM
    Hi there,
    When clicking on the release date, the calendar appears with a default date
    of September 2015. How can the current date or the current month default
    date that appears on the calendar (not in date pre-filled out by the date)?
    See screenshot. Thank you in advance.
    Regards.
    Christian
    2016-04-14 16:20 GMT+02:00 JotForm :

    ...
  • Profile Image
    Ben
    Answered on April 14, 2016 at 01:54 PM

    Since we can assist with one issue / question per thread I have moved your question to a new thread here: https://www.jotform.com/answers/818667 where we will be assisting you shortly Christian.