- KYSCAsked on April 18, 2012 at 06:03 PM
I have a form with Birthdate Picker. When I output to Excel, the birthdates are formated as text.
Ex: October 31, 2000
Would like them to format as date
Or a separate column for each
Column A: 10
Column B: 31
Column C: 2000
Is this possible?
- JotForm SupportMike_TAnswered on April 18, 2012 at 06:32 PM
Thank you for contacting us.
I am afraid that this is not something that you can configure from your side. However, you may consider using DateTime field instead of Birth Day Picker.
To get the date format like this.
If 10-31-2000 format is not acceptable for you, I can raise a ticket to our Development Team in order to switch the output to 10/31/2000, but I can not say when or if this request will be processed.
Please let us know if you need any further assistance.