Null value in a Date column updated with other date column

[#1]

Hello QV Experts,

I have two columns DateReceived & DateApproved.

In DateApproved column having few null values, so that i need to update those DateApproved column with (DateReceived + 5).

Can you please suggest me.

Appreciate your prompt response.

Thanks,
Sasi

[sunny_talwar]

May be this:

LOAD DateReceived,

          Date(If(Len(Trim(DateApproved)) = 0, DateReceived + 5, DateApproved)) as DateApproved

FROM ....

[#3]

Thanks Boss. It worked for me.

[sunny_talwar]

Great