Date conversion

[RaviTeja_1001]

Hi,

I'm trying to write a formula to check between supply date and Bill date. 

Lets assume we have supply date as 29th Feb 2020 and bill date as 15th Mar 2020.

If month and year in supply date (Feb 2020 in this case) = month and year in bill date (Mar 2020)

Then take month and year in Bill date (Mar 2020) if not then give "Prior to month and year in Bill date (Prior to Mar 2020).

Below is the formula that i have used. Can some please help me in this?

Also attached sample data.

If DateTimeFormat([SUPPLY_DT],'%MMM-%YYYY')=DateTimeFormat([BILL_DT],'%MMM-%YYYYY')
THEN DateTimeFormat([BILL_DT],'%MMM-%YYYYY')
ELSE "Prior to"+ DateTimeFormat([BILL_DT],'%MMM-%YYYYY')
ENDIF

Thanks 

[atcodedog05 · Accepted solution]

Hi @RaviTeja_1001 ,

You again missed out on the data file.

You need to save it as packaged workflow if the data needs to intact.

https://www.thedataschool.co.uk/stephanie-kearns/save-alteryx-workflow-packaged-file/

[RaviTeja_1001]

HI,

thanks for the link. 

Please Now i have savved the data as workflow. 

Please find the attached.

[atcodedog05 · Accepted solution]

Hi @RaviTeja_1001 ,

Here is an approach to achieve the purpose.

IF DateTimeFormat(DateTimeParse([BILL_DT],"%d-%b-%y"),"%m-%y")=DateTimeFormat([SUPPLY_DT],"%m-%y")
THEN DateTimeFormat([SUPPLY_DT],"%b-%Y")
ELSE "Prior to"+ DateTimeFormat([SUPPLY_DT],"%b-%Y")
ENDIF

Hope this helps : )

[RaviTeja_1001]

Hi,

Thank you very much.