sql views and dates
Posted on 2013-06-26
I have an sql view that I display on sharepoint using sharepoint data sources.
The field in my SQL view that I want to share is order by is called [date recorded]
The field date recorded is a datetime field and is stored using American formatting as that is the sql server default.
I can get the dates in british format by using this CONVERT(nvarchar, dbo.tblcustomerdetails.[Date Recorded],103 ) however then I cant order by the date as it is no longer a date.
If I try CONVERT(date, dbo.tblcustomerdetails.[Date Recorded],103 ) it still displays as American format.
Is there a way through either the SP data sources or SQL that I can get this to be a date still but displayed in English format.