community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Date Conversions

Meteoroid
Spoiler
Spoiler
Spoiler
 

Hi Folks

 

I have date field in my data set which is not in proper format from 1 to 12 of every month it's reading as yyyy-mm-dd and from 13th of the month it's taking as mm/dd/yyyy.

 

I already tried few thing from previous discussions but nothing worked as such. Please help me out.

Thanks in Advance.

 

Sincerely,

SiddharthaCapture.JPG

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

Could you please pass through some sample data so we can investigate the issue in more detail. 

 

Potentially just select the date field from your datasource and write it to a yxdb.

 

But check out the datetime parse tool, also the 'bb date' tool deals with input datasets that may contain multiple datasets: https://gallery.alteryx.com/#!app/BB-Date/577fe8aba248970840e6dd4d

 

Ben

Meteoroid

:)

Labels