Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Text won't turn to Date

Hi,    I have tried converting my text to date by changing the Data Type formatting in the Column tools but just receive an error. See pic below.  I also tried to create a column with the followin...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I figured it out. I had to create an If statement to get rid of the 0s. Then I created another column with the following equation: 

     

    Column 2 = Date(LEFT(BOOJ30MF[Requested date],4),MID(BOOJ30MF[Requested date],5,2) ,RIGHT(BOOJ30MF[Requested date],2))
     
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

 

Ok I changed both columns to "whole number" then tried to create the measure but it won't find the columns I am trying to pull in.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

That's because you're creating a measure, please create a calculated column with below formula(just keep the data type of column BOOJRSDT and MMDD as Text) and set the date format for it in Column Tools ribbon.

Column = DATE(LEFT('BOOJ30MF'[BOOJRSDT],4),LEFT('BOOJ30MF'[MMDD],2),RIGHT('BOOJ30MF'[MMDD],2))

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    I did that and it still is giving me and error

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I think there is an issue because the date field I am pulling in is coming from a database. I am trying to find a workaround but have been unsuccessful with everything I try. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I figured it out. I had to create an If statement to get rid of the 0s. Then I created another column with the following equation: 

     

    Column 2 = Date(LEFT(BOOJ30MF[Requested date],4),MID(BOOJ30MF[Requested date],5,2) ,RIGHT(BOOJ30MF[Requested date],2))