Importing DateTime using Cfront

brian979

I am trying to import a datetime field into NAV from a text file using cfront however i am getting the following error:

You cannot enter '....' in Datetime, the cursor is in from of invalid character.

Can anyone kindly guide me on what must be done in order to get this to function?

Thanks

rdebath

The format for input of a datetime is the same as the below displays, you may be able to omit the time and switch to a 2 digit year, but other variations are not accepted.

message('%1', format(CREATEDATETIME(01020304D, 050607.089T), 0, 1));