Hello,

I have an xlsx spreadsheet that I mailmerged data from into a .dotx form, with preset fields using the {mergefield} command.

The column in the database is called "DateDue" the cells are formatted to be date fields in the default MM/DD/YYYY format. All data in this column shows the proper date format in the spreadsheet. I did not change any other format setting.

I also have another date column in my spreadsheet for "OrderDate" That one propagates correctly, and all the settings are the same.

So I set up the .dotx form with the proper merge codes and every one of them works except for "DateDue". Instead of merging the actual date, every "DateDue"field in each record in the .dotx form shows "12:00:00AM"

I have edited, deleted and replaced the code a dozen times with no success. I tried one of the other codes in the same spot and it worked perfectly. I even tried the "OrderDate" in that spot, and that worked fine.

I tried using a switch, and all that did was put today's date in the form.

Any ideas why this might be happening?

I'm hoping someone else has experienced this. I am scratching my head about this one, since every other field in the spreadsheet is propagating properly except for this date field.

Thanks for any help.