Forum Discussion

BeatlesForever's avatar
BeatlesForever
New Contributor III
3 years ago

Date Format lost when exporting data from Grid View by Export to Excel XML / SQL Query

Hello,   I created a Grid View to export data from database by SQL query. Some columns should be in number format and others in date format. I defined date format in both SQL query and in Grid Vi...
dashboards
ckattookaran's avatar
ckattookaran
VIP
3 years ago

don't use the FORMAT in SQL, you can do the formatting on the gridview itself. When you use format in SQL, it converts the datatype in SQL to a text.