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
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

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.