Forum Discussion
Converting Text to Date whilst processing for visualisation
Hi Shirley101,
To address the issue, please follow these steps:
First, convert the text-based month names into recognizable date values by creating a new column. Append a day and year to the month name to form a complete date (e.g., "01 January 2025"). Set the data type of this new column to Date to ensure proper recognition.
Next, update your visualizations and relationships to use this new date column instead of the original text-based month column. This will resolve the error and ensure your visual functions correctly.
Please Accept as solution if this meets your needs and a Kudos would be appreciated.
Thank you.
Hello
Unfortunately this hasn't worked for me.
thanks
Shirley101
Hi Shirley101,
To address the issue, please follow these steps:
First, convert the text-based month names into recognizable date values by creating a new column. Append a day and year to the month name to form a complete date (e.g., "01 January 2025"). Set the data type of this new column to Date to ensure proper recognition.
Next, update your visualizations and relationships to use this new date column instead of the original text-based month column. This will resolve the error and ensure your visual functions correctly.
Please Accept as solution if this meets your needs and a Kudos would be appreciated.
Thank you.