Convert 'yyyy-mm-dd' to bigint yyyymmdd

[kartdiv]

Hi , 

I am trying to convert the string date '2019-01-01' to bigint 20190101....how best to achieve this ? Thanks for the help

[bpatel · Accepted solution]

hi @kartdiv 

you can use the data cleansing tool to remove punctuation.

hope this helps!

[Emil_Kos · Accepted solution]

Hi @kartdiv, 

I have prepared a workflow for you.

Unfortunately, you will need to change the data type to string as Alteryx will not allow you to keep a date in a different format. 

Please mark my post as a solution if this was helpful for you!