Dates

[suby]

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

[Jean-Balteryx]

Hi @suby ,

Here is a workflow doing what you need using a Formula tool.

I think you can adapt dates logic based on your need but it works for your example !

[suby]

Hello Jean,

Thanks for your solution and just to clarify one thing 

On my FLAG column formula i want to take condition of my months DIFF BUCKET  = 0-3 months how to bring this into the FLAG column formula.

[Jean-Balteryx · Accepted solution]

You can add AND [months DIFF BUCKET] ="0-3 months" after the > 12 part! 

[suby]

Thanks Jean