syntax in load for if statements

[Anonymous]

so, I want to calculate some flag values..  basically, I want to do something like this..

if((personName = 1) and (todaysDate >= fieldStartDate) and (todaysDate <= fieldEndDate), 1, 0), as IsThereaRealPersonHereStatus

can I have this complex if statement in the data load script?

Thanks,

Maria

[m_woolf]

syntax is:

if(personName = 1 and todaysDate >= fieldStartDate and todaysDate <= fieldEndDate, 1, 0) as IsThereaRealPersonHereStatus

[Anonymous · Accepted solution]

I ended up doing personName * (todaysDate >= fieldStartDate) * (todaysDate <= fieldEndDate) as TheresaRealPersonHereStatus

it seems to work..