Date format

These date formats are supported:

• yyyyMMdd
• yyyy/MM/dd
• yyyy-MM-dd
• ddMMyyyy
• dd/MM/yyyy
• d/M/yyyy
• ddMMyy
• dd/MM/yy
• d/M/yy
• d.M.yy
• MMddyyyy
• MM/dd/yyyy
• MMddyy
• MM/dd/yy
• MM-dd-yy
• MM.dd.yy
• M.d.yy
• M/d/yy
• M/d/yyyy
• M.dd.yy

For two digit years, the Region and Language settings for the server are used to assign the proper century.