Facebook Comment > Appointment Field: Export appointment data into date format in Excel

  • Elton Support Team Lead
    Asked on July 4, 2022 at 9:12 PM

    We have a customer complaining about the appointment field data not getting the proper date format when exported to Excel. I've been trying to come up with an excel formula workaround, but I'm having a hard time extracting the date and time with our current appointment date format on Tables dddd, MMM dd, yyyy hh:mm - hh:mm. I think it would be good if we had a separate column for date and time or a start date/time and end date/time columns. The comment below can be viewed on our FB post here https://fb.watch/e3hQqI269l/.

    1656982265 62c38af9d283f Screenshot 10

  • roneet
    Replied on July 4, 2022 at 11:30 PM

    Hello Chris,

    You can also try this workaround to extract the Date and time from the Appointment field. This will only work for the new submissions.

    1) You can add a Date and a Time element to the form.

    1656991489 62c3af013ec9d Screenshot 10

    2) Now, add a condition to copy the appointment field date into the date picker:

    1656991600 62c3af70c784c Screenshot 21

    3) Another condition to copy the appointment field time into the time element:

    1657083148 62c5150cc1f4f Screenshot 32

    Please follow this screenshot to see the results:

    1656991761 62c3b011176e5 form Screenshot 43

    Let us know if you have any queries on this or if you need assistance in setting this up.