6/17/2019
6462806464
0
6/18/2019
6462806464
0
6/19/2019
6462806464
0
6/20/2019
6462806464
5
6/17/2019
9724996471
0
6/18/2019
9724996471
0
6/19/2019
9724996471
0
6/20/2019
9724996471
0
6/21/2019
9724996471
0
6/22/2019
9724996471
0
6/23/2019
9724996471
0
6/24/2019
9724996471
8
date
Flag
Int32
4
Empty
IF (ToDate(DateTimeAdd([Row-1:Parsed_Date], 1, "days")) = [Parsed_Date] OR ToDate(DateTimeAdd([Row+1:Parsed_Date], -1, "days")) = [Parsed_Date])
AND [oh qty] = 0 THEN 1
ELSE 0 ENDIF
IF (ToDate(DateTimeAdd([Row-1:Parsed_Date], 1, "days")) = [Pa...
date
MM/dd/yy
Parsed_Date
Convert date From:
MM/dd/yy
C:\Users\thales.d\AppData\Local\Temp\Engine_7904_e02f8957e75d4a498edf9a622bb927dc_\Engine_2600_59081d9affac47a3a775e280cf04483c_.yxdb
Single
Profile
Horizontal
ConsecutiveDaysStock