Excel is not considering my date value as date even after I tried many formatting? Need suggestion
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.
0
Best Answer
-
Hello @User_90781
I am not sure what version of BIP are you on but please see the below doc. Maybe this will help.
Excel Outp Date Format Display Does Not Pick Up Formatting From RTF Template (Doc ID 2089844.1)
0
Answers
-
See Formatting Dates in
Rgds,
Kevin
0