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

  • Profile Image
    Elton
    Asked on July 04, 2022 at 09: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_

  • Profile Image
    Roneet
    Answered on July 04, 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_

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

    1656991600_62c3af70c784c_

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

    1657083148_62c5150cc1f4f_

    Please follow this screenshot to see the results:

    1656991761_62c3b011176e5_form.gif

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