how to change the date format for scheduling

system · August 29, 2012, 2:29pm

Hi All,

I have scheduled the report to email with excel format and I gave the data and time from specific name option . then my excel name and data has come as name , but its showing date with time stamp also. I want show only date.

I gave Myexcel_%SI_STARTTIME%.%EXT%, then my out name coming as Myexcel_2012-08-29-12-30-40.xls. after the date its giving hrs-mm-ss also.
I want see only date like Myexcel_2012-08-29.

Please help me,
BOXIR3, Oracle 10g

srinu.bos (BOB member since 2007-06-06)

system · August 29, 2012, 2:31pm

Looks like it is bringing up the server date. So please try modifying it in the Server.

RUC (BOB member since 2010-05-03)

system · August 30, 2012, 9:13am

Hi,

Actually i gave %SI_STARTTIME%, if i give %SI_STARTDATE% then its giving date without time stamp.

Thanks

srinu.bos (BOB member since 2007-06-06)