Hello All,
I'm trying to calculate the Date logic but not getting expected result so I've mocked up a sample workflow with Input Data set and screen shot of expected results.
- New column called as (months DIFF Bucket) logic to determine the new column
Condition 1 - months difference between CURRENT DATE and FUTURE DATE and flag values as 0-3 months.( See attached Expected Output)
- Second New Column called as (FLAG)
Take the condition 1 from the above step and check where the months DIFF Bucket = 0-3 months and then take the CURRENT DATE and check CURRENT DATE Date is between 12 and 15 months post the CHECK DATE.( See attached Expected Output)
- Third New column called as FINAL
CATEGORY = ELECTRONICS OR CATEGORY HOUSEHOLD AND
months DIFF Bucket = 0-3 months AND
FLAG = 12-15 months THEN 'YES' ELSE 'NO'
Any help would be much appreciated.
Attached the Sample workflow with Expected Output Screen shot.
Thanks
