>Hi,
>In each record I need to recognize date type and if value is .null. replace with date().
>How ?

if ISNULL(field_name) and TYPE("field_name")="D"
replace ......


>If I pass null values to Excel how can change latter value of cell to date() ?

You may use Excel Automation.

>
>TIA, gojko