Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
first calculate the datediff between 2 dates then apply if condition like
if (field1 >=-30 and field1 <=30,'yes','no')
That's the way I did it but doesn't seem to work
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