How to get submission date as variable in the form

hi guys

is there a way to  get submission date as variable in the form?

the problem actual date is pushing from cellphone and some times it just puts the date of yesterday and not the actual gmt-4

Please kindly provide a bit more information on your inquiry. Where exactly would you like to see the submission date (e.g. form Inbox, PDF document, form Submissions, somewhere else)? This may also help if you can show where you see the wrong date.

 form Submissions

because on submission date it takes the server date

while on date value (fecha) the cellphone and sometimes its from yesterday

so I want to calculate Fecha from submission date:

https://eu.jotform.com/build/201305024780039

You need to change the TimeZone on the account settings page. It is currently set to America/La_Paz (GMT-4). 

How to Change Submission Date to a Different Format and Timezone

yes, I have it already.

But the current date widget is getting some times yesterday:

https://www.dropbox.com/s/74icgpvnx8btjd5/Screenshot%202020-05-29%2006.16.23.png?dl=0

Here responses: https://www.dropbox.com/s/12lts4iq5jqhkql/Screenshot%202020-05-29%2006.17.53.png?dl=0

All forms are filled in Bolivia, it seems a cellphone related issues, how can we fix it? submission date is always correct, if it could be passed as variable to my date. It could solve the problem.

Thank you for your reply.

I have tested the form, but unfortunately, I was not able to replicate the problem.

Can you please try to use another field, for example, a Date picker, and let us know if the problem is still present?

Please note that by removing the existing field from the form, you will also remove all existing data from that field. 

Let us know if the problem is present in this field as well.

Thank you for your cooperation. 

nope that doesnt select hidden the date of today: https://www.dropbox.com/s/sw0g1mf0j9ln5nn/Screenshot%202020-05-29%2009.12.22.png?dl=0

I agree with you that it may have something to do with Mobile's timezone.

Submission Date follows your account's timezone while the Date Picker captures the machine's. Can you please share with us the timezone set on your mobile so we can try replicating the same on our end?

Alternatively, you can create a short video of submission, upload it to any free cloud storage (eg. Google Drive, Dropbox), and then share the link for us to view it.

Looking forward to your response.

I want date picker to capture account time zone

how do we capture it in a variable apart of submission date?

Hello, I am looking into this possibility. I will get back to you shortly.

Unfortunately, it is not possible to get the time difference between your timezone and the user's as a column in the submissions. You can get the difference later using excel formula, or if you are embedding your form with the full source code, you can use JavaScript's getTimeZoneOffset function.

Getting the full source-code: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

JS timezone: https://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp 

Let us know if you need further assistance.  

it still nothing and not very good way of getting date from account instead of cellphone cause im getting random dates

can you scale it to development please?

it should be just a simple setup setting 

Greetings and thank you for your reply.

If you wish to capture your user's time zone, you are able to use the Hidden Box widget. This widget will allow you to see what is the timezone of the user who filled the form. You can click here to learn more about this.

However, this will not allow you to use calculation with the time, you are only able to see the timezone.

Please let us know if this solution will work for you.