Tell me the rows with duration withing -30 days or + 30 days..

[D19PAL]

Hi,

I have two date columns and I want an if flag statement to

Tell me the rows with duration withing -30 days or + 30 days..

So if date one and date 2  within 30 +\- days yes, if -31 or 31 or more then no.

Thanks

[anat]

first calculate the datediff between 2 dates then apply if condition like

if (field1 >=-30 and field1 <=30,'yes','no')

[D19PAL]

That's the way I did it but doesn't seem to work

[MarcoWedel]

Can you post a small application to show what exactly you did and how your expected result is different from what you currently have?

thanks