Hi guy's

Im trying to pass variables into nawk and then match them on a value within a record but it don't seem to be working. If i put in the dates i want to see then it works fine..

#!/usr/bin/ksh -x
YEST=$(/usr/local/bin/perl -e '@T=localtime(time-86400);printf("%02d/%02d/%02d\n",$T[4]+1,$T[3],($T[5]+1900)%100)')
DATE=$(date +%m/%d/%y)
MON=$(date +%m)
DAY=$(date +%d)
YEAR=$(date +%y)

bpdbjobs -report | /usr/bin/nawk -v DATE=$DATE -v YEST=$YEST '
{
if ( NF == 13 )
if ( $12 ~ /07\/09\/05/ || $12 ~ /07\/10\/05/ || $12 ~ /07\/11\/05/)
if ( $3 ~ /Done/ && $4 > 0 )
print

elseif ( NF == 12 )
if ( $11 ~ /07\/09\/05/ || $11 ~ /07\/10\/05/ || $11 ~ /07\/11\/05/)
if ( $3 ~ /Done/ && $4 > 0 )

print

}'

I want to have the following line looking like this and using the variable, if that makes sense


if ( $12 == YEST || $12 == DATE )

print


although this doesn't work how i would like i have even tried splitting up the %d / %m / %y but still no joy. Is some control symbol used to tell awk it is a variable with a value ?

Thanks in advance...

Kenny