Forum Discussion

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago

Text to Date

Hi,   Why am I unable to change TEXT to DATE for a column.     Regards Malvika  
Need Help
Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Hi MalvikaBhasin 

 

Go to Transform data to the table, highlight the column and convert to Date

 

Joe

  • MalvikaBhasin's avatar
    MalvikaBhasin
    Helper III
    2 years ago

    Thanks. But why is it working partially for me? Can you help identify issue from below image?

     

     

    Regards

    Malvika

    • mostho's avatar
      mostho
      Helper II
      2 years ago

      How does the column look like before the transformation? i guess the "dates" are in a format which the function cannot handle by default. maybe you have to adjust the function call with an optional culture parameter or a format specification.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago
      Hi, Perhaps the cells where you see errors, the date format there is m/d/y. Since your system is formatted to only understand d/m/y dates, those cells are returning errors.
    • SachinNandanwar's avatar
      SachinNandanwar
      Impactful Individual
      2 years ago

      Your data contains dates in the format dd/mm/yyyy.

      For instance the input date 13/01/2024 is formatted as day/month/year. But the report expects dates in the format mm/dd/yyyy where the month value should not exceed 12. So when the report encounters a date with a month value greater than 12 it would create an error.