CDate doesnt work in Report Viewer? Where can I get the manual about this?
Hi all,
I have worked on Report Viewer in Zenon.
- Zenon: version 11.0
- MS Report Builder: version 15.0 (5/2023)
Then in the report (*.rdl), I use the function CDate in cell expression, for ex: =CDate("11/27/2022")
The function works well if I run the report file by MS Report Builder. However, when Zenon loads the report file into Report Viewer, the function results: #Error
Did I wrong or miss any configuration steps?
Where can I find and released notes or guides on expression in MS Report Builder that is supported by Zenon?
FYI:
My purpose is to format the display of the data 's timestamp. For ex: I have 1-hour average data, so I want to display the time as in hour "MM/yy hh:00", and hide minutes and seconds, for ex: 11/25 01:00 AM.
So I will use the functions: Format(CDate(timestamp), "MM/yy hh:00")