Google Spreadsheet: Incorrect Date Format

  • Profile Image
    debs2105
    Asked on November 09, 2013 at 11:32 AM

    Hi I have now set the data up to automtically go to google drive which is fantastic but..... some of the date entries are showing as the following format 9/12/2014 and some as 09-12-2014 so it will not sort the info properly please advise as to why?

  • Profile Image
    khrisell
    Answered on November 09, 2013 at 08:42 PM

    Hello,

    Can you share us the google spreadsheet link or simply a screenshot of it so that we could check the error you are currently having.

    Thank you and we will wait for your response to assist you further on this.

  • Profile Image
    debs2105
    Answered on November 10, 2013 at 07:22 AM
    hi khrisell
    here is the url for the sheet, as you can see for some reason the arrival
    date and departure dates are showing in different formats through the
    column which make sit impossible for me to sort by date range:
    https://docs.google.com/spreadsheet/ccc?key=0Ah7bCzYU_AbzdGYxdHNOUDJQODhVUXZ6Zm5TdGxHcWc&usp=sharing
    Kind Regards
    Deborah Smith
    *www.delaterre.eu.com *
    T: 0033 (0)627963657
    *De La Terre provide Catering services and meal deliveries to
    ski chalets and apartments in Samoens and Morillon. *
    De La Terre customers will receive a discounted price when booking their
    transfers with MST . Please quote MST100
  • Profile Image
    jonathan
    Answered on November 10, 2013 at 08:43 AM

    Hi Deborah,

    I was able to see this inconsistent behavior of the data in your form's integrated spreadsheet.

    But I would like to gather more details before we can elevate the issue to our next level support.

    I am assuming that this is the form involve http://www.jotform.com/32644484996369 

    May I inquire if the form is embedded on a website? Please share to us the URL of the website where we can test the form used.

    If not embedded on the website, can you confirm that you only uses the form using its direct URL http://www.jotform.com/32644484996369 ?

     

    We will await for your updates.

    Thanks.

  • Profile Image
    debs2105
    Answered on November 10, 2013 at 09:59 AM
    hi
    it is embedded on a website here as well the link is this: Our chalet
    owners booking form via our
    website
    Kind Regards
    Deborah Smith
    *www.delaterre.eu.com *
    T: 0033 (0)627963657
    *De La Terre provide Catering services and meal deliveries to
    ski chalets and apartments in Samoens and Morillon. *
    De La Terre customers will receive a discounted price when booking their
    transfers with MST . Please quote MST100
  • Profile Image
    Welvin
    Answered on November 10, 2013 at 11:56 AM

    Can you please re-paste the webpage URL? We can't see it from your last reply. Also, did you try re-integrating the form to Google Spreadsheet? Can you try that? See if that will resolve the issue.

    Thank you.

  • Profile Image
    debs2105
    Answered on November 10, 2013 at 12:28 PM
    hi I have re intergrated the form in google spreadsheet and it seems to be
    fine now. thank you
    Kind Regards
    Deborah Smith
    *www.delaterre.eu.com *
    T: 0033 (0)627963657
    *De La Terre provide Catering services and meal deliveries to
    ski chalets and apartments in Samoens and Morillon. *
    De La Terre customers will receive a discounted price when booking their
    transfers with MST . Please quote MST100
  • Profile Image
    Welvin
    Answered on November 10, 2013 at 12:38 PM

    Great! Please be sure to let us know for any issues with your forms. We are here to help.

    Thanks