Google Drive Integration - format submission date for custom folder name

I'd like to be able to include the submission date as part of the folder name that is created with submissions when integrated with google drive. I've seen that I can do that by adding {time} as part of the name like below:

While this seems straightforward, the reason I want to be able to include the date in the folder name is to be able to easily sort the submission folders by the date they were submitted. The folder name that is created, though, has a date format of "dd/mm/yyyy hh:mm:ss" as shown below:

This format doesn't work for sorting by submission date as it would sort april 9, 2015 ("09/04/2015") prior to march 10, 2015 ("10/03/2015"). I'd prefer a format of yyyy/mm/dd. Is this doable by including another field (a datetime field with default date enabled will not work because this field cannot be used as part of a custom google folder name in the current integration). Is there a way to format the already included submission date?

I've reviewed these threads (seemingly related), but I still can't find a solution.

http://www.jotform.com/answers/301785-Google-Drive-integration-Wrong-date-time-for-the-name-of-the-submission-folder

http://www.jotform.com/answers/405710-Google-drive-integration-include-submission-date-in-custom-folder-name

http://www.jotform.com/answers/434184-Bug-Report-Date-Field-Does-Not-Sort-By-Date-In-Grid-Reports

Any help is appreciated. Thanks!

The DateTime field have an output format of yyyymmdd so you can use it in the Textbox you can use as the Google Drive assigned Custom Folder name.

I made a Calculation condition to populate a hidden Textbox that I will use as the Custom Folder Name in GDrive integration

I setup in the integration

The output in the Google drive is like this

You can test submit my demo jotform http://www.jotform.me/form/50686861218462 where I have implemented the method.

You can check the result in the shared Google folder here.

Hope this help. Let us know if there is more we can assist you with.

Thanks.

Great workaround. Thank you!

@moddlerA,

Your question will be answered here: http://www.jotform.com/answers/538453.

Thank you!