|Applies To||RSA Product Set: Archer|
RSA Version/Condition: 5.5.x
|Issue||When 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()))
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.