Creation Date field will not put in date with import action
I want to import data from an excel file.
I imported all without problems except that upon import, the newly created records from the import action do not trigger the Creation Date field.
The Creation date field for all the records created are blank. Now if I create a new record manually with CTRL N, the Creation Date field works as it should.
Can anyone tell me how I can get the Creation Date field to activate with imported data creating records?
Any help here would be greatly appreciated.
I have FMPro Advanced 11.0 v3OS - Windows Vista on desktop, Windows 7 on laptop