sysdate in "Value if Null"

[jparrott]

I need to put the value of sysdate in the &quot;Value if Null&quot; property for one of my fields. I tried just putting 'sydate' and '&<sysdate>', but I got this error:

REP-0613: Value does not match mask: 'DD-MON-RR'
ORA-01858: A non-numeric character was found where a numeric was expected

Anyone have any suggestions?

Thanks,
Justin

 

[sem]

You can not use variables there, only literals. Try to add NVL to your query.

Regards, Dima

 

[bandarna]

I agree with Dima. you have to user nvl there in the query.