In a template that uses a variable file upload in which one of the fields that comes from the variable data file that is a date that you would like to appear in a Month day, year format, if you format the field as a date in excel, the comma will not import. eDoc
Builder will not read the formatting from Excel. It will only read the
value. You have two options to remedy this:
1) Format the fields as text in Excel.
2) Use a VB script to
format the date. The script would look like this:
format_date(DateField, "m e, y")
Obviously you would replace "DateField" with the name of the field that contains the date from the file upload.
Article ID: 351, Created: 6/10/2013 at 10:47 PM, Modified: 6/21/2013 at 7:33 PM