BI publisher report is showing 00-01-1900 instead of correct date
Hello,
when we run the BI publisher report it shows the dates (00-01-1900) instead of correct date. in the XML file the dates shown with correct format (01/11/2018) and constant is appear correctly in the excel, but the dates with incorrect format in XML file (2018-11-01) and retrieved as variable is showing (00-01-1900) in the resulted excel file.
Thanks in advance.