Skip to main content
Question

Remove time stamp from quick report Aurena

  • March 3, 2023
  • 2 replies
  • 92 views

Forum|alt.badge.img+10

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

Forum|alt.badge.img+12
  • Hero (Partner)
  • April 21, 2023

Hi,

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

 


Forum|alt.badge.img+6
  • Sidekick (Employee)
  • July 26, 2023

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.