IF THEN Formula

Question

The current data transformation process calculates monthly volumes based on a "J1 date."  This is the attachment with the record column.

The objective is to modify this process to utilize a "P-code date" instead when there is a p-code date availbale in the EE arch launch date.. The existing data includes a calculated monthly volume and a "P-code date" field, with the possibility of missing "P-code date" values. The goal is to create a new field representing annual volume, correctly accounting for the different starting dates.

P-code date attachment is the input

P-code output is the result I need it in.

I would appreciate any help.

Thank you

P code date.JPG

P code output.JPG

Qiu · Answer

@Destinitruth 
Maybe you can share the data set rather than the Snapshot?

OTrieger · Answer

@Destinitruth

I'm trying to understand your question. The time is IF THEN Formula and in the output file you inly modified the data format.

To change date format there are different tools that you can use. You first goal will be to convert it to Alteryx date format, and you can do it with DateTime Parse tool.