000029642 - Mail Merge Date field Issue; displaying 1 day less than the actual date.

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

Article Content

Article Number000029642
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition:
Platform: Windows
IssueIn the Policies application, a client has a Published date field and they are embedding that field in a Mail merge template. The value of the Date field in the Mail Merge is displaying as a date that is 1 day behind the actual date. 
CauseThis is a known defect that was logged internally as Release Tracker 7340294: "Date displays yesterday’s date in mail merge export document." 
ResolutionThe defect was fixed in V5.5 and higher. 
WorkaroundCreate a Calculated field to add 1 day to the Date only field and use the Calculated field in the Mail Merge.