Excell Export date field

  • Profile Image
    andylash
    Asked on February 18, 2021 at 03:02 PM

    I'm trying to build a pivot table off of my form submissions. The date field is exporting as a "General" field and the timeline slicer is not recognizing the general field. Is there something I can change to get the report functioning correctly?

  • Profile Image
    Sonnyfer
    Answered on February 18, 2021 at 07:50 PM

    Hi there - I'm not an expert in Excel but I believe you can change the format from General to Date.

    1613695788_602f0b2c613de_

    Have you tried this already?

  • Profile Image
    andylash
    Answered on February 19, 2021 at 09:06 AM

    Yes, I worked several simple changes in Excel before asking here. I ended up having to use several functions to remove the leading 0 that the jot form export has on single digits months.


  • Profile Image
    Sara_G
    Answered on February 19, 2021 at 11:34 AM

    Hi,
    Hope you could solve your issue.
    Please let us know if you have further requests.
    Kind regards.