Automatic email-with Subject line containing the previous date
Below is the Query i use to get Automatic mail from unix
nohup bteq <pn_store_info_2011.bteq> store_transaction.out 2>&1 &
/*zip SAC_Tire SAC_Tire.xls*/
(cat store-message.txt; uuencode Store_Level_Trans.xls Store_Level_Tran.xls) | mailx -s "Store Level Transaction Report" -r "Automotive " `cat mailpcp_Store.dat`
my query is - the subject line should be like "Store Level Transaction Report-April 04/2012" that is i will be running the code daily and my subjcet should contain yesterday date.
2. also my attachment also should have the yesterday date.
i Tried few option but not working.
Any help would be Great.pls..