Dates ?

[suby]

Hi All,

I have a sample Input Data and expected Output in the attached workflow.

I want to the find difference in Months between the SECOND DATE & FIRST DATE and bucket it.

Attached the sample workflow.

Thanks.

[Luke_C]

Hi @suby 

See attached. This can be accomplished with the datetimediff function after converting your values to be valid dates. Then bucketing can be done with a few IF statements.

I recommend you bookmark this link on dates, it is super helpful to refer to: https://help.alteryx.com/current/designer/datetime-functions

[Qiu]

@suby 
I use the DateTimeParse function.

The result for A1, A5 A6 are different but the input seems to be same.