XSD validation format for mm-dd-yyyy


  • i have a an excel file which contains a date value ; the excel file is converted into xml and then validated against a schema.

    one of the field is of type datetime where i want to restrict it to have the value of mm-dd-yyyy

    where jan 3rd 2013 will be 1-3-2013 not 01-03-2013 "zero" needs to be avoided for mm and dd.

    How do i achive that in date.


    Tuesday, July 23, 2013 8:37 PM


  • Not sure if xsd:date datatype can be far more specified as mm-dd-yyyy.

    In VBA You can just loop the ranges and check each range numberformat as below


    Best Regards,
    Asadulla Javed, Kolkata
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    Wednesday, July 24, 2013 8:54 AM