How can you set column format when exporting to excel?

Posted 99 days ago by BlazorRazor

I've scoured the entire internet, to no avail. 
I want to change my date column to be formatted as "date" in excel.

The "format" in my gridcolumn is for modifying the data in my DB. (Picture 1)
However when I export my table, the date is formatted as a general text. (Picture 2)

I would like the column to appear formatted like this in excel. (Picture 3)
I've already tried changing the format type in the gridcolumn but it didnt change anything in excel.

Any ideas? 

Someone is typing...

Post a Reply

You must be logged in to add a new post.
Number of online users: 1
An error has occurred. This application may no longer respond until reloaded. Reload 🗙