Zapier integration is showing numeric values as dates

  • tomastrigo
    Asked on June 13, 2019 at 9: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. 

    Jotform Thread 1855987 Screenshot
  • Alan_D
    Replied 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. Zapier integration is showing numeric values as dates Image 10All 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. Zapier integration is showing numeric values as dates Image 21Zapier integration is showing numeric values as dates Image 32Also, you can be sure the integration will fill your Excel file with these readable values. Zapier integration is showing numeric values as dates Image 43

  • tomastrigo
    Replied on June 18, 2019 at 6:16 AM

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