Short Date Format

[Tame]

Hello,

My input date has two date columns. I would like to change the format to make the date shorter. the current date format looks like this: Jun 27, 2023 12:00:00 AM which is long. How can I make these two date fields shorter? 

Can you please help me :) ?

[Qiu · Accepted solution]

@Tame 
We can use the DateTImeParse function in Formula tool as below.

You can check the Specifiers of DateTime function in below.

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#idm46037954415808

[Tame]

Hi Thank you for helping, but what does that %b... means? do I need to add those as well?

[flying008 · Accepted solution]

Hi, @Tame 

%b = The abbreviated month name (Feb, Oct), as your 'Jun' .