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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Date = Date(left([column],4),mid([column],6,2),right([column],2)

 

If it has already column detected as date try to change the format

 

You can also create a formatting

Formatted Date = format([New date],"YYYY/MM/DD")