Birthdate picker Export to Excel format

  • Profile Image
    KYSC
    Asked 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

    Ex: 10/31/2000

     

    Or a separate column for each

    Ex:

    Column A: 10

    Column B: 31

    Column C: 2000

     

    Is this possible?

  • Profile Image
    Mike_T
    Answered 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.