I am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel is not considering it as a date eventhough the column format is date.
The problem is eventhough the date is in the expected format, I could see while using filter it looks like it is taking this as a string not as a date. Please refer the attached screenshot for reference.
