my excel sheet contains a column called expiry date.in that column there are about 1000 dates.and each dates are given in separate formats.such as dd-mm-yyyy, mm-dd-yyyy, 01-jan-2010, jan-24-2011,etc...when i try to map this column in card exchange using customized format dd-mm-yyyy,it doesnt appear.for some,it appears in a correct way.bur for some it comes mm-dd-yyyy format.so how can i map these column in a right way??
The day-month order in the Excel file must match the local system settings. CardExchange cannot know whether the day or the month is given first other than looking at the system settings (American or European date representation).
Senior Software Engineer
"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)