Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Excel is not considering my date value as date even after I tried many formatting? Need suggestion
User_90781
Rank 1 - Community Starter
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