Hi,
I am trying to figure out how to change for example "APR 2018" to "4/30/2018". Please note "APR 2018" is in V_WString format. I tried to change it on the select tool but it will not work. Also, "APR 2018" was taken from the file path.
Solved! Go to Solution.
Hi @Ahasan13
Use a DateTimeParse, DateTimeTrim, and DateTimeFormat function:
DateTimeFormat(DateTimeTrim(DateTimeParse([Date],'%b %Y'),'lastofmonth'),'%m/%d/%Y')
Helpful information: DateTime Functions | Alteryx Help
Hi @Ahasan13
I would utilize the DateTime tool and use the custom option to convert this date to 4/30/2018. Below is a sample image.
Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.
Thanks it worked!
I am glad it worked. Would you be able to like the post and mark it as a solution so other users can reference it as a solution when searching within the community?