John Smith
01/01/2017
John Smith
01/03/2017
John Smith
03/20/2017
John Smith
06/01/2017
Mike Jones
02/04/2018
Jane Doe
02/01/2018
Jane Doe
02/01/2018
Tom Abernathy
05/05/2017
Tom Abernathy
05/15/2017
Tom Abernathy
05/29/2017
Tom Abernathy
05/30/2017
Date
MM/dd/yyyy
DateTime_Out
Convert Date From:
MM/dd/yyyy
Name
Distance to Next Date
Int32
4
NULL
datetimediff([Date],[Row-1:Date],'days')
datetimediff([Date],[Row-1:Date],'days')
LookupDate
Date
10
[Date]
LookupDate <= Datetimeadd([Date],3,'days')
datetimeadd(LookupDate,1,'days')
RecordID
1
Int32
6
0
[RecordID]<=[Right_RecordID]
Custom
=
True
fixed
2018-07-12 21:06:32
0
2018-07-12 21:06:32
2018-07-12 21:06:32
[RecordID]<=[Right_RecordID]
Horizontal
Solution