Set analysis Last 6 month

[mario-sarkis]

Hey,

my question is the following:

i have a data that contain :

ID        Interaction-date

x          12/31/2014

w          2/3/2015
e          11/3/2014

y           3/3/2015

u           2/3/2014

o           8/3/2015

p           5/5/2015

PS :My date form is like this not number

i need to this show a list that show only the id that i didnt had and interation with in the las 6 months , and i need to show their count into a text box.

Thank you

[richard_chilvers]

Hi Mario

This should be fairly straight-forward but you first need to decide what you mean by last 6 months?

Today is 12 August, so do you mean any date in August, July, June, May, April, March ?

[mario-sarkis]

Yes Richard i need to show LIST of ID that their interaction-Date is less then March  and a TEXT BOX coutn these iDs,

How to calculate and show this?

Thank you ,

[Anonymous]

Hi Mario,

Try this out

=only( {< [Interaction-date] = {'<=month(today())-6'}>} ID)

[richard_chilvers]

Yes, that's the idea, but it would compare a date with a month and not perhaps be so good. I'd prefer to use the MonthStart() function which gives the date of the first day of a month.

[Anonymous]

Perhaps something like this then.

=only( {< [Interaction-date] = {'<=date(addmonths(today(),-6))'}>} ID)