Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Riette
New Member

Help with Changing date format: Expression.Error: The name 'FORMAT' wasn't recognized.

‎07-27-2021 06:44 AM

Hi everyone.

I have dates in the format 6/15/2021 for example, which are in text but I can't change the to date type until I replace the format to include zero's so its in this format 06/15/21. Another example date 4/5/2021 needs to be 04/05/2021. How can I have the format updated for this in the Query editor? Any help is much appreciated. 

Labels:
Message 1 of 4
620 Views
0
3 REPLIES 3
aj1973
Community Champion
Community Champion

‎07-27-2021 06:49 AM

Hi @Riette 

Have you tried "Using Locale"!

aj1973_0-1627393755676.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Message 2 of 4
616 Views
0
Riette
New Member
In response to aj1973

‎07-27-2021 06:51 AM

Yes I tried that first but it doesn't seem to work, I assumed it was because the format wasn't right to start with.

Message 3 of 4
614 Views
0
aj1973
Community Champion
Community Champion
In response to Riette

‎07-27-2021 07:20 AM

The source! what type is it?

Can I see it?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Message 4 of 4
581 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All