Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
VeronikaStolfa
Frequent Visitor

DataFormat.Error: We couldn't parse the input provided as a Date value

Hello all, could you please help me to get rid off the date error: DataFormat.Error: We couldn't parse the input provided as a Date value

 

I used conditional column below ->

 
 

image.png

 

 

After that when I changed format to a date the mentioned error has appeared. I tried to change locale to English (American Samoa, Japanese

6875d3ca-7d6d-4467-bfb7-45aae75b53da.png

Thank you in advance!

1 ACCEPTED SOLUTION

Open advanced editor and you will notice double quotes around "#date(2020,1,1)"

Remove these double quotes from there and the problem will be solved

View solution in original post

3 REPLIES 3
Vijay_A_Verma
Super User
Super User

Can you click on Error and post the screenshot here?

Hello Vijay,

 

image.png

Open advanced editor and you will notice double quotes around "#date(2020,1,1)"

Remove these double quotes from there and the problem will be solved

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors