Populate custom date on date field through update field condition

Hi,

Depending on what you are trying to do, the date field lets you add and subtract values to update another date field.  For example, this condition:

Would take the date in the first field, move the date forward 95 days, then insert the new date into the second date field.  Here is my test form to show you how it works:

http://form.jotformpro.com/form/50844949917976

http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

Let us know a bit more detail about what you are trying to get working and we will be happy to help.

@nlpmarin 

Thanks for your clarification. After running some tests, I can confirm that it is not possible to populate custom date on the date field through update field condition. Let me add this as a feature request instead so our developers will be able to consider this in the future.

You may consider using regular text boxes for now for prepopulating date text.

Thanks!

I feature request ticket had already been submitted. 

We will let you know here for any update on the status.

What do I do if I want to insert a specific date?

Did you meant you want the specific date to be manually inserted?

If you will add an input box where you wanted to insert the specific date, you should be able to use it to manually update/populate the Start Date also.

If you do not want to have a manual input field to add the specific custom date (if you want all manual input to happen on hidden condtion logic only), you can also just used the Calculation as described already by our colleague David previously.

Please try my example jotform http://www.jotformpro.com/form/50926177000953

The calculation condition I setup is like this

it works like this

as you can see, to have the specific date, you can just indicate a +/- date on the current date to indicate the exact date.

Please let us know of your feedback on this.

Thanks.

We can "populate" the DateTime field with numeric values to get the actual dates. Javascript uses 1970-01-01 date as a start point for time values, so we will need to calculate a difference in days between needed date and 1970-01-01.

For example, use:

http://www.timeanddate.com/date/durationresult.html

Then, 'Update a form field value' condition:

Form example:

http://form.jotformpro.com/form/50927635365967

Thank you.

Please take note that to get the correct number of days (result), the Start Date to should always be 1/1/1970 (January 1, 1970 or the Epoch Time reference)

If you checked the conditional statement set in Mike_T's sample form http://form.jotformpro.com/form/50927635365967

the correct number of days to calculate was set similarly to what was calculated in the date calculation tool.

when I checked the sample form of Mike_T, it was calculating correctly and filling the Date field with the correct date.

From what I understand in your screenshot, the exact date you wanted to assign is September 18, 2015 -- which is 16696 days from 1/1/1970

I applied the same calculation using a clone of Mike_T's sample form http://form.jotformpro.com/form/50937356457970?

and it is working correctly

I am curious how you were able to get this screenshot

was this from the test form http://form.jotformpro.com/form/50927635365967 ?

It is weird that we have different result.

Hope this help. Let us know if still not resolved.

Thanks.

When I checked your jotform http://form.jotform.us/form/50906777138161 I again got the result off by a day compared to your result.

It is now obvious that the difference was due to the location time zone difference.

My current location time zone is GMT +800 while you seems to be at EST.

I could not figure out yet how to overcome the difference and make it use a specific/fixed time zone. 

But the good thing here is, there is no issue in your current form conditional statement. So, it should be good as is by now.

I will search more how to go about the different time zone issue. We will update you here once we got a resolution for it.

Thanks.

I opened this ticket again so that the developer may have a look.  We will update you here as soon as we have any further information.