Date string syntax "dd/mm/yyyy" is invalid

Date string syntax "dd/mm/yyyy" is invalid

Issue:

Interactive reports created before v5.5.22 which contained a filter on column 'HW EOL DATE (calc)' or 'SW EOL DATE (calc)', cannot be opened on v5.5.22

Error:

 Date string syntax "xx/xx/xxxx" is invalid

Cause:


Following columns were in string type before 5.5.22, but were changed to be Date type in 5.5.22:
1. HW EOL DATE (calc)
2. SW EOL DATE (calc)

Workaround:

This issue can be manually fixed with following steps.
1. Open the old report.
2. Close the pop up error.
3. Edit the filter, as the screenshot below:

editFilter.PNG

4. After editing the filter, the report can be opened. Then save the report again in order to save the edit so that it can be opened without any errors next time. 

afterEdit.PNG

Was this article helpful? Yes No
No ratings
Version history
Revision #:
2 of 2
Last update:
‎Nov 04, 2019 11:07 AM
Updated by:
 
Contributors