Trust ID PBCEX logo 300x102

mapping

10 years 3 months ago
support
Fresh Boarder
Fresh Boarder
Posts: 1
More
Topic Author
mapping #1172
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??
10 years 3 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
mapping #1174
Hi support,

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

regards,
Rutger.

Rutger Koperdraad
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)