Hi All,
I have a requirement based on clients there are event dates captured and I have to compare those dates with today and see the last date passed and the nearest date coming.
for eg. Client A has last date Jan'19 i.e Header Date 2 and next date Dec-19 i.e header Date 5 whereas for client B last date should be Jan-19 however header Date 4 and next date Jan-20 i.e header Date 5.
Attaching .twbx and excel file.
I hope I am able to put the requirement properly.
Thanks
Ankit
For the next upcoming date, you can use the MIN version and check for the date > TODAY()
MIN(
MIN(
MIN(
MIN(
MIN(
MIN(
MIN(
MIN(
MIN(
MIN(IF [Date1] > TODAY() THEN [Date1] ELSE MAKEDATE(2100, 1, 1) END,
IF [Date2] > TODAY() THEN [Date2] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date3] > TODAY() THEN [Date3] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date4] > TODAY() THEN [Date4] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date5] > TODAY() THEN [Date5] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date6] > TODAY() THEN [Date6] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date7] > TODAY() THEN [Date7] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date8] > TODAY() THEN [Date8] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date9] > TODAY() THEN [Date9] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date10] > TODAY() THEN [Date10] ELSE MAKEDATE(2100, 1, 1) END),
IF [Date11] > TODAY() THEN [Date11] ELSE MAKEDATE(2100, 1, 1) END)
