Skip to main content
Participant
May 16, 2014
Question

Importing dates from Excel 2013 (XML)

  • May 16, 2014
  • 0 replies
  • 236 views

Hi all,

So I have a fully mapped (and otherwise perfectly functioning) Excel file which my organization uses to load data into PDF forms. Unfortunately I cannot get dates to work correctly. Here is the error I get on Import:

"Invalid date/time: please ensure that the date/time exists. Field [xxxxx] should match format m/d/yyyy"

I've tried everything I can think of. The formats are identical for both the cells (XLSX side) and the fields (PDF side). I should note that I am exporting an XML file from Excel, rather than using FDF or XFDF.

Any help would be greatly appreciated!

Thanks in advance!

    This topic has been closed for replies.