Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Julio
I think you had a misplace bracket, try this.
if( len(trim([Claim Close Date]))=0 and [Status Claim] = 'Closed', date( [Claim Opened Date] + 60 ) ,[Claim Close Date]) as [Claim Close Date],
Red ) added & second ) before as removed so leaving just one )
Best Regards, Bill
Hi Julio,
Try this
if(isnull([Claim Closed Date]) and [Status Claim] = 'Closed', Date([Submitted Date] + 30)) as EXPECTED
if( isnull([Claim Closed Date]) and [Status Claim] = 'Closed', date( [Submitted Date] + 30 ) as [Claim Closed Date] ,
if( len(trim( [Claim Closed Date] ))=0 and [Status Claim] = 'Closed', date( [Submitted Date] + 30 ) as [Claim Closed Date] ,
this one doesn't work fine for me, because i would to be filled out inside the [Claim Closed Date], but thanks
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] ,
It doesn't allow me to have two fields with the same name in this case...
Julio
Then get rid of the original one and just leave the new one.
i did, it worked, but brings for me no data on this field now...
Julio
Can you paste in your load script.