Reply
Highlighted
Regular Visitor
Posts: 34
Registered: ‎04-29-2018
Accepted Solution

Change text to date

Hello Everyone

 

I got a problem changing my text column into a date colum, i got the date like this 2018-01-10 (yy-mm-dd) but when I use this formula: 

real date =
IF (
    PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL] = "0000-00-00";
    BLANK ();
    DATE ( LEFT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 4 )RIGHT ( LEFT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 4 )2 )RIGHT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 2 ) )
)

my result is wrong: like this 10/6/2019 0:00:00, yes 2019 not 2018!

 

Does anyone Know what is happening?

Also the day is wrong

 

Thanks!

 


Accepted Solutions
Community Support Team
Posts: 5,403
Registered: ‎09-21-2016

Re: Change text to date

Hi @christianyepez2,

 

There existing a mistake when using above formula to extract Month value from text. 

 

Please modify it to:

 

real date =
IF (
    PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL] = "0000-00-00";
    BLANK ();
    DATE ( LEFT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 4 ); RIGHT ( LEFT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 7 ); 2 ); RIGHT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 2 ) )
)

 

Best regards,

Yuliana Gu

 

View solution in original post


All Replies
AlB Super Contributor
Super Contributor
Posts: 794
Registered: ‎11-12-2018

Re: Change text to date

Hi @christianyepez2

 

Does it not work by changing the date type of the column from text to date?

Community Support Team
Posts: 5,403
Registered: ‎09-21-2016

Re: Change text to date

Hi @christianyepez2,

 

There existing a mistake when using above formula to extract Month value from text. 

 

Please modify it to:

 

real date =
IF (
    PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL] = "0000-00-00";
    BLANK ();
    DATE ( LEFT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 4 ); RIGHT ( LEFT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 7 ); 2 ); RIGHT ( PP_ORDENESPRODUCCION[FECHA_ENTREGA_REAL]; 2 ) )
)

 

Best regards,

Yuliana Gu