I'm not sure why they are displaying differently, but you can Edit
Columns on each and set the format to {0:d} to get the short date
format you want. The only caveat is that you also have to set the
HTMLEncode value to false for the format property to be observed. I've
read that doing so might expose some sort of security risk, but I don't
know the nature or level of severity.
HTH,
Rich
Hennie wrote:
I have 2 gridviews on a page, each with own SQL Datasource pointing to
different tables on same database.
In the 1st date format is "dd/MM/yyyy"
Other 1
"MM/dd/yyyy hh:mm:ss"
In the SQL database both fields are data type DateTime.
I want both to be in format "dd/MM/yyyy"
Why is the display different, and how can I get them the same?
Thanks