Question

Remove time stamp from quick report Aurena


Userlevel 4
Badge +9
  • Sidekick (Customer)
  • 58 replies

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!

 

 


2 replies

Userlevel 6
Badge +11

Hi,

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

 

Userlevel 1
Badge +4

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