I have been successful fifty percent in my requirement. i worte this syntax EXP userid=scott/manager owner=scott rows=y file=c:\BCP_SCOTT_%DATE% and getting export file with name according to current day of date like: BCP_SCOTT_Mon BCP_SCOTT_Tue BCP_SCOTT_Wed BCP_SCOTT_Thu BCP_SCOTT_Fri BCP_SCOTT_Sat BCP_SCOTT_Sun but i want export file with names like BCP_SCOTT_Mon_06_10_2008 BCP_SCOTT_Tue_07_10_2008 BCP_SCOTT_Wed_08_10_2008 BCP_SCOTT_Thu_09_10_2008 BCP_SCOTT_Fri_10_10_2008 BCP_SCOTT_Sat _11_10_2008 BCP_SCOTT_Sun_12_10_2008 So please tell me how i can add/concatenate this(_05_10_2008) in filename.. ????????????????? Regards to all friends

Hi, Have you tried something like: EXP userid=scott/manager owner=scott rows=y file=c:\BCP_SCOTT_%date:~11%_%date:~8,2%_%date:~5,2% ? Date format can vary so it may need a little tweaking. Hth, Elinor Elinor Hurst http://elinorhurst.blogspot.com

Hi Elinor Hurst, i am very thankful to you. you solved my problem. again thanx. Regards, Imran