Change Date format

[srk0609]

I have attached a file with i/p and expected o/p( in yellow background). If there is HBT in reference then the date in Reference is o/p else we have to add 1 month to date to get o/p can anyone help? I also attached excel file. Thank you.

[binuacs · Accepted solution]

@srk0609 One way of doing this

[flying008]

Hi,@srk0609 

FYI. ( In your want output , the "22" is year or day ? )

IIF(Contains([Reference], "HBT"), DateTimeAdd([Date],ToNumber(REGEX_Replace([Reference], "[\D]", ""))-1,"day"), DateTimeAdd(DateTimeAdd([Date],ToNumber(REGEX_Replace([Reference], "[\D]", ""))-1,"day"),1,"month"))

[grazitti_sapna]

@srk0609, another way to approach this problem.

Thanks!

[srk0609]

Hi @flying 008,

The 22 is year. Thank you for the help. I will review the wf you provided.

[srk0609]

Hi,

In my alteryx designer I have a column with value 31-MAY-22 and I want to convert it to date 2022-05-31 so that I cn use your formula. Can you please help? Thank you

[DataNath · Accepted solution]

@srk0609 can use:

DateTimeParse([Date],'%d-%b-%y')

[srk0609]

Thank you for your help

[srk0609]

Hi DataNath,

Could you please help me with this issue? Thank you

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Extract-data-from-middle-of-Excel-with...