SELECT Suref, FORMAT(DateFrom, 'd', 'en-gb') AS 'Great Britain English format' FROM [dbo].[BOCClientIndex - AdultServiceDetails] WHERE [DateFrom] >= '01/01/2020' Order by DateFrom
SELECT Suref, FORMAT(DateFrom, 'd', 'en-gb') AS 'Great Britain English format' FROM [dbo].[BOCClientIndex - AdultServiceDetails] WHERE [DateFrom] >= '01/01/2020' Order by DateFrom