Dear experts,

I would like to migrate data from a table from baan4 to LN.

But in baan4, the dates are converted to values of 6 digits. (using baan number)
In LN, the dates are converted to values of more than 6 digits. (using date number)
I guess it is because in LN, the dates are in UTC.

So how can i migrate the data in this table? What must I do to change the dates so that LN can read it correctly?

Thanks and regards

Hi,

my first thought: In LN read into date fields using a condition like following


domain tcdate utc_num
long ret

ret = local.to.utc(date_num, 0, utc_num)

return(utc_num)


Where date_num is the numeric ASCII field containing Baan IV date number which must be defined as parameter for the condition

This is how I do it for Baan4 to Baan5 migration. (May work for LN as well)

Source exchange scheme (Baan4) , in maintain ascii file formats for the date field, select the appropriate date format (eg. DDMMYYYY). Do not select "Baan number".

Target Exchange Scheme (Baan5 or LN), in maintain ascii file fields, set the date format of the field same as that selected in the step above.

Baan will take care of the conversion.