fill in missing values

[Anonymous]

Hi,

I have a date field in my table but not every row has a date. For those rows that doesn't have a date i want them to have todays date.

How do i do this? It has to be done in the script.

Thanks!

[#2 · Accepted solution]

Hi,

If you take the data from a sql query, you can use the NVL function. Otherwise, use;

if(isnull(field) = -1, today(), field)

[Anonymous]

Annika,

If the values without dates are null values you can do the following in the script:

Load

     Date,

     if(Len(Date)=0, Today(), Date) as NewDateField

From xxx..

[Anonymous]

Thank you Guys!

Just what i needed!

//A.