Forum Discussion
Aamir_khan
Kudo Collector
Kudo CollectorChange Text date format to Date type
Hello All I am facing some issue while Change Text date format to Date type I want Change Text date "2020-04-21" format to Date type 2020/04/21 but how?
Hi , Aamir_khan
right click Date colum ->Chage type ->Using locateFor more details , please refer to this post.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Aamir_khanKudo Collector
Kudo CollectorI try this solution but in some of the date gets errors
Mariusz
Community Champion
Community ChampionHi Aamir_khan
Can you paste a sample with some good and bad ( errors ) examples?
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
- Aamir_khan
That's because you want to parse in the US format while you should in the UK one... or the other way round. You have to convert using Change Type with Locale.
If you scan all the messages in this thread... you'll notice a picture in which there's an option "Using Locale..." You have to use it.
Best
D- Aamir_khan
How will I change that