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

Alteryx designer Discussions

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

I have a problem with my date formula

Atom

Hi,

 

if i have a date in this format 15/1/15 the result will be 2015/1/2015

 

check out the attachment.

 

thanks 

Asteroid

Hello Alidrs,

 

This is one where you are best to use a tool to do the job!

 

You need to use the DateTime tool configured to dd/MM/yy as in the below screenshot.

Alidrs.PNG

Atom

the problem with this tool is that if the date is 1/1/50

it will be 1/1/2050

where it should be 1950

Alteryx
Alteryx

You can do it all in one formula tool like you are trying but its far easier to follow the logic if you break it out into a couple of tools.  I have used text to column and a formula tool to recombine it with the relevant 19 or 20 prefix.

 

V2018.3

Alteryx
Alteryx
 
Atom

Thank you

 

I was just hoping to do it in one tool

Labels