|Applies To||Archer 5.x|
|Issue||While 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.