I have an issue with the formating of date fields. SQL2000 requires the a date to be inside single quotes. I am trying to use an if statement to validate Null and date fields:

if ($FORM{TX_DT})
{
&datechecks($FORM{TX_DT}, 'TX');
$TX_DT = $FORM{TX_DT};
}
else
{
$TX_DT = NULL;
}
I need the correct way to put the value $FORM{TX_DT} in single quotes.

also can anyone tell me the best way to test the scripts I am very new with this.

Thanks