Calculated date format

I have a date field entry in my form. The user enters it in month, day, year format.

After the user enters the date, I need to have a field that uses the month, day, year entry and changes it to year, month, day format.  

Eventually, I will hide that field in the form but then it will show in my google sheet integration.

Any ideas?

You can add two date picker fields. One for the MM/DD/YYYY Format and the other for the YYYY/MM/DD. Then you use the Update/Calculate Field condition to copy the fields value of Date1(MM/DD/YYYY) to Date2(YYYY/MM/DD).

This condition will convert the dates to the correct format automatically.

You then make sure the "Clear Hidden Fields Values" is set to Don't clear in your Form Settings.

You can now hide your date 2 and integrate your Form with Google Sheet.

https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets

Sample screenshot:

Sample Form:https://form.jotform.com/83530499759978

Please give it a try and let us know if you have further questions.