How to extract date from V_WString format

Below is my input from excel and Alteryx is reading it in V_WString. I need to extract the date i.e. Jul-20. Can anyone help me out on priority as I am in the middle of automating one file? Thanks

01-Jul-2020 3:59:44 PM

Data.xlsx

Workflow

Accepted answers

bhrmitra

Hi Aggsneh,

Apologies I missed you datetime format.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Extract date from V_WString format - Abhra Mitra.yxmd

All comments

bhrmitra

Hi Aggsneh,

It seems you forgot to attach your input file.

Thanks,

Abhra

Aggsneh

File has been attached. Thanks

markcurry

Hi @Aggsneh

If your date is in the format '01-Jul-2020 3:59:44 PM' and you just want the Month and Year, in another String variable, use the formula Substring([Date],3,8) which will give you Jul-2020. But if you want Jul-20, then use Substring([Date],3,3) + "-" + Substring([Date],9,2)

If you want to convert that format to an Alteryx Data format, then use the DateTime tool, which the function Custom format of dd-Mon-yyyy hh:mm:ss

Hope that helps.

bhrmitra

Hi Aggsneh,

Apologies I missed you datetime format.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Extract date from V_WString format - Abhra Mitra.yxmd

grazitti_sapna

Hi @Aggsneh, this formula will resolve your issue, fastest and efficient way to achieve.

Formula-DatetimeFormat(Datetimeparse([Date Accessed],"%d-%b-%Y"),"%b-%y")

Thanks.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703