how do I convert 31-Dec-2018 to 12/31/2018 using the formula tool?

htalteryx

Thanks!

Help

Accepted answers

Thableaus

Hi @htalteryx

Try this:

DateTimeFormat(DateTimeParse([Field1],"%d-%b-%Y"), "%m/%d/%Y")

Cheers,

All comments

Thableaus

Hi @htalteryx

Try this:

DateTimeFormat(DateTimeParse([Field1],"%d-%b-%Y"), "%m/%d/%Y")

Cheers,

cmcclellan

I was confused by your post, but I think I figured it out.

When Alteryx is using dates, the format it always yyyy-mm-dd

So I'm guessing you're using a string that contains "31-Dec-2018" or more precisely "dd-mmm-yyyy". If the string is called [string_date] then use this:

DateTimeFormat(
	DateTimeParse([string_date],'%d-%b-%Y')
,'%m/%d/%Y')

2019-02-08 07_52_48-Alteryx Designer x64 - New Workflow13_.png

The DateTimeParse turns the string into a date, which makes it easy to do the DateTimeFormat and show in the format that you want.

htalteryx

Thank you so much! I've been looking everywhere for this! I would never have figured this out on my own!

One more question: how do I convert 2018-12-31 to 12/31/2018 using the formula tool?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703