000029612 - DataFeed/Data Import 'DateTime' field conversion

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000029612
Applies ToArcher 5.x
IssueWhile importing data into a DateTime field in Archer the value you specify inside the import file will be considered as GMT and will be pushed into DB. This article provides a workaround to import the date & time specifying the timezone.
You can apply this calculation to your date field in DFM: 
CONCATENATE([Date Field]," ","EDT") 
And the time will be imported as whatever time zone you specify. You would need to change it to EST when the clock changes in the fall. I'm attaching a sample application package and dfx5 to explain this workaround.