Add Yesterday's date at runtime

[Techy Teck]

I am running *Hive 0.6 *and below is the content I have in *hivetest1.hql*file.

set mapred.job.queue.name=hdmi-technology;
set mapred.output.compress=true;
set mapred.output.compression.type=BLOCK;
set mapred.output.compression.codec=org.apache.hadoop.io.compress.LzoCodec;
add jar UserDefinedFunction.jar;
create temporary function rank as 'com.example.hive.udf.Rank';


insert overwrite table testingtable3 partition (dt='*20120805*')
select * from testingtable3 where dt = '*2012-08-05*';


And I am running the above *hivetest1.hql* file like this from the shell
prompt-

*hive -f hivetest1.hql*
*
*
So my question is- Is there any way to always use the yesterday's date in
the red color whenever I want to run the above *hivetest1.hql file *from
the shell prompt*.*
*
*
Any suggestions will be appreciated.