HOW DO I CHANGE DATE FORMATS IN FORM.

  • Profile Image
    tanica
    Asked on May 26, 2012 at 10:21 AM

    I HAVE A PROBLEM IN DOWNLOADING DATES IN EXCEL. EXCEL IS NOT ABLE TO RECOGNISE THE FIELD AS A DATE FIELD BECAUSE IT'S "01 JANUARY 2012" OR 12-01-2012 AND THAT IS NOT ACCEPTABLE FOR EXCEL. SO I HAVE TO CHANGE IT TO 12.01.2012.

    IS IT POSSIBLE TO DO THAT?

     

    THANKS

  • Profile Image
    abajan
    Answered on May 26, 2012 at 04:41 PM

    Just the other day, another user discovered this problem and a ticket was submitted to our developers to rectify it. However, in your case, I think that switching each date field's format back to its default (mmddyyyy) should solve the problem.