I have a program that populates a PF, and then this file is downloaded as a CSV to a Windows PC using Client Access. The CSV file is then opened in Excel and saved as an Excel 97 file. This is because the credit card printing software we use needs it in Excel in order to import it properly. Credit cards are then printed from that data.
One problem I'm having is with a field that contains the credit card expiration date which is just a string in the format MM/YY. So for example, the expiration date might be 1/18 and this is what we want printed on the card. But when the file is opened in Excel, it interprets the string "1/18" as a date and assumes that it's MM/DD and then it adds on the current year, so it thinks that I mean 1/18/2016. So before importing into the credit card printing software, I have to change that field to ="1/18" to force Excel to treat it as a string and not a date.
There must be a better way... any ideas?
One problem I'm having is with a field that contains the credit card expiration date which is just a string in the format MM/YY. So for example, the expiration date might be 1/18 and this is what we want printed on the card. But when the file is opened in Excel, it interprets the string "1/18" as a date and assumes that it's MM/DD and then it adds on the current year, so it thinks that I mean 1/18/2016. So before importing into the credit card printing software, I have to change that field to ="1/18" to force Excel to treat it as a string and not a date.
There must be a better way... any ideas?
Comment