Oracle Analytics and AI

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.