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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Slowpoke1
Frequent Visitor

Date Field General Date But Displays As Long Date

Wondering if anyone has come across this issue before and found a solution. I'm working with a dataset with a live connection and the date column is showing as General Date in the model view but when the field is dropped into a table, it's displayed as Long Date. The dataset itself has the column listed as type date.

 

How can I get it to display as mm/dd/yyyy? I don't believe a measure can be a reliable workaround since it requires some kind of min/max on the date correct?

 

Slowpoke1_0-1689715654031.png

 

Slowpoke1_1-1689715680299.png

 

2 REPLIES 2
amitchandak
Super User
Super User

@Slowpoke1 , Manually edit the format once in column tools and try

@amitchandak - The report is using live connection so editing in column tools is not an option.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.