Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
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 ,
Hi Mario,
Try this out
=only( {< [Interaction-date] = {'<=month(today())-6'}>} ID)
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.
Perhaps something like this then.
=only( {< [Interaction-date] = {'<=date(addmonths(today(),-6))'}>} ID)