cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Change Date format from dd/mm/yy to mm/dd/yy

HI,

 

how can i change date format from mm/dd/yy to dd/mm/yy?

 

i checked some of the solutions about splitting the column, and merging them as mm/dd/yy.

 

Is there any other way to do it. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Change Date format from dd/mm/yy to mm/dd/yy

@Paridhisharma

 

Hi, in Query Editor,Right Click in the column -  Change Type-Using Locale - Select the Type (Date Time) and Select the Locale.

 

Regards

 

Victor




Lima - Peru

View solution in original post

3 REPLIES 3
Highlighted
Resolver I
Resolver I

Re: Change Date format from dd/mm/yy to mm/dd/yy

Hi @Paridhisharma,

 

Did you try the FORMAT function in dax? 

 

https://msdn.microsoft.com/en-us/library/ee634924.aspx

Highlighted
Community Champion
Community Champion

Re: Change Date format from dd/mm/yy to mm/dd/yy

@Paridhisharma

 

Hi, in Query Editor,Right Click in the column -  Change Type-Using Locale - Select the Type (Date Time) and Select the Locale.

 

Regards

 

Victor




Lima - Peru

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Change Date format from dd/mm/yy to mm/dd/yy

Hi @Paridhisharma,


Please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

Thanks,
Angelia

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors