000033421 - Calculation date does not match date in RSA Archer 5.5.x

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

Article Content

Article Number000033421
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5.x
IssueWhen using a formula that includes the TODAY function, the date is shown as the incorrect day.
Example Formula: IF (ISEMPTY([Date of Closure]), IF ([Status]="Closed,TODAY(),NOVALUE()))
User-added image

Each time a record is recalculated, the calculated field will display an updated date. Internally, the "TODAY" function returns a serial number that represents the number of whole days that have elapsed since January 1, 1900. From the user perspective, the value returned by the "TODAY" function will display differently depending on the type of field to which the value will be returned.
This issue occurred due to the data and times being converted to Greenwich Mean Time (GMT) in the RSA Archer database. As a result, dates and times in calculations are returned in GMT. In this case you may want to explore using a different function like "NOW".