Skip to main content

Hi, Need some help to remove the time stamp on the dates in Aurena quick report so that we can easily filter the report from the screen before downloading. I have tried TRUNC and also TO_DATE which both work in EE but not in Aurena which leads me to believe there is some other setting. Thanks!

 

 

Hi,

(I know its late but) can I see your query if you are still interested?

 


Try TO_CHAR to convert the date column to a character value, for example TO_CHAR(planned_start_date, 'YYYY-MM-DD'). This worked when I tested it in Apps10 Aurena.


Reply