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')
Identify date difference between last and next occurrence, grouped by person
DateTimeDiff([Date],[Row-1:Date],'days')
C:\Users\claje03\AppData\Local\Temp\Engine_22480_82af486ceffc456eafb22a67fd66b70c_\Engine_9232_acaffeae93e2481fbe7c2b7ea9c61af7_.yxdb
Single
Profile
Join on Name so that every name has all associated dates
RecordID
1
Int32
6
0
Add an ID for each record coming in for sort and 3 day count
[RecordID] <= [Right_RecordID]
Custom
=
True
fixed
2018-07-12 16:11:36
0
2018-07-12 16:11:36
2018-07-12 16:11:36
Filter to only compare future dates
[RecordID] <= [Right_RecordID]
Check if each future date is in 3 days of the current one
Total per record
C:\Users\claje03\AppData\Local\Temp\Engine_22480_82af486ceffc456eafb22a67fd66b70c_\Engine_9232_9a080ba3bc7840f198f0bd5cf58217e9_.yxdb
Single
Profile
Horizontal
Claje_DtCompare