Datepart query

[jeffwest2]

I am trying to determine how old something is, using this formula

if datepart("d",{SITUATIO.Start Date}) >= (datepart("d",CurrentDate))-0
and datepart("d",{SITUATIO.Start Date}) <= (datepart("d",CurrentDate))-89
then "<3 months" else
if datepart("d",{SITUATIO.Start Date}) >= (datepart("d",CurrentDate))-90
and datepart("d",{SITUATIO.Start Date}) <= (datepart("d",CurrentDate))-179
then "3 - 6 months" else
if datepart("d",{SITUATIO.Start Date}) >= (datepart("d",CurrentDate))-180
and datepart("d",{SITUATIO.Start Date}) <= (datepart("d",CurrentDate))-364
then "6 - 12 months" else
if datepart("d",{SITUATIO.Start Date}) >= (datepart("d",CurrentDate))-365
then "> 1 Year"

Only problem is, despite having dates that are only a few weeks/months old, it only seems to return the last value.

Anyone help with this please, it really is annoying me.

 

[IanWaterman]

Its because all your data meets the last condition.

YOu need to extend the formulas to exclude the previous data sets.

Ian

 

[jeffwest2]

Sorry, confused, how can everything meet the last value, when i have specified ranges before it, as i said, i have data where the date is only 3 months old, yet it always says it is older than a year

 

[IanWaterman]

May be this formula is wrong

if datepart("d",{SITUATIO.Start Date}) >= (datepart("d",CurrentDate))-365

should be

if datepart("d",{SITUATIO.Start Date}) <= (datepart("d",CurrentDate))-365

Ian

 

[jeffwest2]

That's it, thanks, i had the <= & >= the wrong way round