Filling blank fields with dates

[#1]

People, I have a problem in my database that I have a field called "[Claim Closed Date]", that sometimes it comes blank for me. I would like to create a rule for that, this rule has to be like this: I have another field called "[Status Claim]" and another one called "[Submitted Date]", so, I would like to put like this in the script:

...

[Claim Closed Date],

[Status Claim],

[Submitted Date],

....

if([Claim Closed Date] = "Blank (?)" and [Status Claim] = 'Closed', FILL WITH [Submitted Date] + "30 days",,)

how do I do such thing in the script??

[jvishnuram]

Hi Julio,

Try this

if(isnull([Claim Closed Date])  and [Status Claim] = 'Closed',  Date([Submitted Date] + 30)) as EXPECTED

[Anonymous]

if( isnull([Claim Closed Date]) and [Status Claim] = 'Closed', date( [Submitted Date] + 30 ) as [Claim Closed Date] ,

[maxgro]

if( len(trim( [Claim Closed Date] ))=0 and [Status Claim] = 'Closed', date( [Submitted Date] + 30 ) as [Claim Closed Date] ,

[#5]

this one doesn't work fine for me, because i would to be filled out inside the [Claim Closed Date], but thanks

[Anonymous]

Julio

This will put the data into a field called [Claim Closed Date]

if( isnull([Claim Closed Date]) and [Status Claim] = 'Closed', date( [Submitted Date] + 30 ) as [Claim Closed Date] ,

[#7]

It doesn't allow me to have two fields with the same name in this case...

[Anonymous]

Julio

Then get rid of the original one and just leave the new one.

[#9]

i did, it worked, but brings for me no data on this field now...

[Anonymous]

Julio

Can you paste in your load script.