Date displays incorrectly in Financial Reporter
Problem
The cell format in Excel has been changed to display long date formats but dates are still displayed in short style in Financial Reporter.
Date format is a function of Excel. As date formats are displayed as strings, a formula would be required in Excel to change the format.
Solution
Change the format by using the Excel formula DATEVALUE. Any string value within the parentheses will be changed to implement the cell format properties.
Example:
To change date format for session date use the following formula:
=DATEVALUE(FR("SessionDate"))
See also