Date format

[tww]

Hi all,

How could I format/extract the following value so I can get 2 separate values for the weekday and date.

Wed Aug 31 23:30:17 CDT 2022

Output

Wed	08/31/2022

Thank you

[Yoshiro_Fujimori · Accepted solution]

@tww ,

DateTime functions can handle date and time very frexibly.

https://help.alteryx.com/20223/designer/datetime-functions

Used formula

Date = DateTimeParse([Data],"%a %b %d %H:%M:%S CDT %Y")

DayOf Week = DateTimeFormat([Date],"%a")

Date2 = DateTimeFormat([Date],"%m/%d/%Y")

Workflow

Output

Good luck!

[martinding]

Hi @tww , 

You can try the following approach:

1. Parse the string to datetime format

2. Format the datetime into the parts you want (e.g. day of week, year, date)

[tww]

Thank you, @Yoshiro_Fujimori 

[tww]

Thank you, @martinding