Cannot convert a string to a date format

[ivoiculescu2020]

Dear team,

I need your help again: I need to convert a string field to a date with this format: dd-mmm-yyyy

I used the DateTime to convert the string to date/time format but it shows Null

I chose custom: dd-Mon-yyyy but nothing happens.

Please help!

Thank you,

Ioana

[Luke_C · Accepted solution]

Hi @ivoiculescu2020 

Give this a go:

1. First you need to parse the date into an actual date (in Alteryx, the format is yyyy-mm-dd).
2. Then you can format to your requirement

Here's a great page on working with dates: DateTime Functions | Alteryx Help

datetimeformat(datetimeparse([completedTime],'%a, %B %d, %Y'),'%d-%b-%Y')

[Alteryx_AR · Accepted solution]

@ivoiculescu2020  Same as @Luke_C . 

[binuacs · Accepted solution]

@ivoiculescu2020 

[ivoiculescu2020]

@binuacs @Alteryx_AR @Luke_C Thank you so much for your help! your solutions worked and I appreciate your prompt help!

[Alteryx_AR]

Hey @ivoiculescu2020  Thanks for accepting as solution :)