How to filter the last end date for each group and display the datediff

[NishiR27]

Any suggestions please

MoreID	SNoId	Id	EFF_LOW_DT	Min_EFF_HI_DT	Max_DateDiff in Days
4444	2222	11	10/28/2014 0:00	8/13/2018 0:00	1385
4444	2222	11	8/13/2018 0:00	12/31/2099 0:00	29725
4444	2222	11	8/13/2018 0:00	12/31/2099 0:00	29725
4444	2222	11	8/13/2018 0:00	8/13/2018 0:00	0
4444	2222	22	10/28/2014 0:00	12/31/2099 0:00	31110
4444	2222	33	7/15/2015 0:00	10/2/2020 0:00	1906
4444	2222	33	10/2/2020 0:00	5/29/2024 0:00	1335
4444	2222	33	5/29/2024 0:00	6/14/2024 0:00	16
4444	2222	33	6/14/2024 0:00	12/31/2099 0:00	279

[shancmiralles]

hi! what do you mean each group? do you mean ID (column) group? and what do you mean by "last end date"? you have 2 columns for dates , do you mean the most recent date for the 2 columns? it would be great if you can provide what are the records/rows that you need to show out of the given input you provided above. thanks! @NishiR27 

[flying008 · Accepted solution]

Hi, @NishiR27 

FYI.

DateTimeDiff(DateTimeParse([Min_EFF_HI_DT],'%m/%d/%Y %H:%M'),DateTimeParse([EFF_LOW_DT],'%m/%d/%Y %H:%M'),'day')

[NishiR27 · Accepted solution]

@flying008 - Thank you so much! This worked as expected.