on Jun 14, 2016Article Content
| Article Number | 000029612 |
| 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. |
| Resolution | 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. |