Forum Discussion

Aamir_khan's avatar
Aamir_khan
Icon for Kudo Collector rankKudo Collector
6 years ago
Solved

Change 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?  
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Aamir_khan 
    right click Date colum ->Chage type ->Using locate

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

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Aamir_khan
Icon for Kudo Collector rankKudo Collector
6 years ago

How will I change that 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , Aamir_khan 
    right click Date colum ->Chage type ->Using locate

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