Zapier integration is showing numeric values as dates

  • Profile Image
    tomastrigo
    Asked on June 13, 2019 at 09:45 AM

    Good Morning


    I'm using Zapier integration to write a row in an Excel file (in OneDrive for Business) every time there is a new submission.

    I'm having some issues in passing the submission date. It passes as a numerical value (which is fine) but for some reason, that particular field doesn't get written in the Excel File. 

    Any insights are welcomed. 

    Screenshot
  • Profile Image
    Alan_D
    Answered on June 13, 2019 at 11:30 AM

    Your DX Self Assessment form does not contain any date fields. I think you are wanting to send Submission date and Update date to your Excel sheet. 15604395261.pngAll dates correspond to a numeric value. You are seeing these values in tests. You can think this is a communication way between Jotform and Zapier. Please Re-test this step to see readable dates. 15604395642.png15604396483.pngAlso, you can be sure the integration will fill your Excel file with these readable values. 15604397024.png

  • Profile Image
    tomastrigo
    Answered on June 18, 2019 at 06:16 AM

    Thank you for your quick answer. It did the trick!