000029612 - DataFeed/Data Import 'DateTime' field conversion in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 19, 2019
Version 6Show Document
  • View in full screen mode

Article Content

Article Number000029612
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x, 6.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.
ResolutionThere are a couple of options for importing the date with the correct time zone.
  1. Import the data from a data feed or an import with the time zone included. For example:
    4/5/2019 7:00 AM EDT
  2. Apply a calculation to your date field in a Data Feed. Here is what the calculation would look like:

    CONCATENATE([Date Field]," ","EDT") 
The time will be imported as whatever time zone you specify. You cannot use ET so you would need to use EDT or EST depending on the time of year. Attached is a sample application package and dfx5 to explain this.