Anti Ohne 21.Jan.04 03:24 AM a Web browser LEILEI - 3.1AIX
I have problems with importing date/time fields from an export file created by an AS400 system to a Notes database. For this I use a text connector and a Notes connection in combination with a Direct Transfer Activity.
In the text connection I specify the structure of the import file via a ZID decription. The date I import with this specification:
"IMPORTDATE: TYPE DATETIME FORMAT YYYY-MM-DD-uu.mm.ss START 24 END 42 TRIM"
For example: "2004-01-19-07.40.40"
When I review the results in the Notes document I notice that the time is not 07.40.40 but 00.40.40, which is 7 hours earlier. I think I have a timezone problem.
How do I specify that the date/time is in the correct timezone (same timezone as the export file). I looked throught the LEI documentation and I can't find an answer.
Environment specs: AIX / Domino 5.0.11 / LEI 3.1a, AS400 text file is on the AIX system