Date Conversion Issues

[hudg16]

I'm having some issues converting my date format. It is a v_string for reference

The error is

ConvError: DateTime (27): Month1: Cannot convert "30Nov2020" to a date/time with format "DD%bYYYY" and language "English": Expected separator 'DD%bYYYY', got: '30Nov2020' Record #1

Any suggestions?

Cheers

[Luke_C]

@hudg16  Try putting in %d%b%Y 'DD%bYYYY' isn't valid syntax.

[apathetichell]

ddMonyyyy is another way (which may be clearer) for using the date/time tool - @Luke_C 's suggestion will work as well, and his also works in a formula tool with datetimeparse (ie datetimeparse([date field],"%d%b%Y")

[Qiu]

@hudg16 
If we still want to stick on your DateTime Tool we can do it like this.

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