none
XSD validation format for mm-dd-yyyy

    Question

  • 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.

    THanks,

    Tuesday, July 23, 2013 8:37 PM

Answers

  • 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

    range.numberformat="mm-dd-yyyy"


    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