Need straightforward functions in OACS to format Date in different formats like

Ravi Bhuma -Oracle

Organization Name

DEPARTMENT OF HEALTH AND HUMAN SERVICES

Description

 

we need more other simpler functions available in OACS for DATE FORMATTING as per user requirement, to easily change the DATE FORMAT in output to any format(dd/mm/yyyy or DD-MON-YYYY or dd-mon-yy with timestamp'  etc.,)

Unable to find a straightforward function in OACS to format Date in different formats like 'DD-MM-YY' or 'DD-MON-YYYY' etc.,
Using Create analysis section, built a new report using the existing subject areas.
User wants to have the Date Format to be displayed as 'DD-MON-YYYY' in the text outputs.
As there are no TO_CHAR/TO_DATE functions available in Edit formula section of a column, we have used the below function to achieve the required result.

  CONCAT(SUBSTRING(CAST("Requisition Lines"."Need By Date" AS CHAR) FROM 1 FOR 7),CAST(YEAR("Requisition Lines"."Need By Date" ) AS CHAR)

Is there any straightforward function available to have the date format displayed in any required format 'DD-MON-YYYY' or 'dd/mm/yyyy'  or 'DD/MON/YYYY' etc.,

 

 

Use Case and Business Need

All users are not able to achieve the required output and having straight forward date functions as explained earlier would be very helpful

More details

we need more other simpler functions available in OACS for DATE FORMATTING as per user requirement, to easily change the DATE FORMAT in output to any format(dd/mm/yyyy or DD-MON-YYYY or dd-mon-yy with timestamp'  etc.,)

Unable to find a straightforward function in OACS to format Date in different formats like 'DD-MM-YY' or 'DD-MON-YYYY' etc.,
Using Create analysis section, built a new report using the existing subject areas.
User wants to have the Date Format to be displayed as 'DD-MON-YYYY' in the text outputs.
As there are no TO_CHAR/TO_DATE functions available in Edit formula section of a column, we have used the below function to achieve the required result.

  CONCAT(SUBSTRING(CAST("Requisition Lines"."Need By Date" AS CHAR) FROM 1 FOR 7),CAST(YEAR("Requisition Lines"."Need By Date" ) AS CHAR)

Is there any straightforward function available to have the date format displayed in any required format 'DD-MON-YYYY' or 'dd/mm/yyyy'  or 'DD/MON/YYYY' etc.,

 

 

Original Idea Number: e177434911

Luis E. Rivas -Oracle

Hi Ravi - maybe I'm not understanding fully - but in Viz and in Data Prep there is a way to easily change the formats of the dates - If you select the column containing a date, the lower left hand corner has the column properties and you are able to select the clock icon and chose from various pre-set date formats or create a custom format.  Have you tried this? I'm attaching a picture for your reference.

 

 

User_JXK10

Hi Louis,

Thanks for your reply. I am Sindhu from Dept of Health working in Oracle Analytics cloud. We have recently implemented OACS in our dept and I have raised an SR with oracle for the Date format issue. Please find the screenshots of our OACS screen, wherein I am unable to change the Date format to any custom date format as per user requirement.

 

In the screenshots, I have tried to change the date format of "LAST UPDATE DATE" field  to DD-MON-YYYY and the result is not showing the correct format. Please let me know if you need more inputs.

 

Regards,

Sindhu