cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Extract Month and Year from DateTime field to get MMM-YY

I have a date column As of Date in my table Status, I need to extract month and year from this column. How do I do that

1 ACCEPTED SOLUTION

Accepted Solutions
rocky09 Senior Member
Senior Member

Re: Extract Month and Year from DateTime field to get MMM-YY

customDate = FORMAT ( 'TABLENAME'[Date], "MMMYY" )

 

create New Column and use above

3 REPLIES 3
rocky09 Senior Member
Senior Member

Re: Extract Month and Year from DateTime field to get MMM-YY

customDate = FORMAT ( 'TABLENAME'[Date], "MMMYY" )

 

create New Column and use above

Community Support Team
Community Support Team

Re: Extract Month and Year from DateTime field to get MMM-YY

@ApurvaKhatri,

 

You could also add a custom column in Query Editor.

Date.ToText([As of Date], "MMM-yy")
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Extract Month and Year from DateTime field to get MMM-YY

This Date.ToText os not working in my case