Hi,

I have a code in my ASP.NET application that shows a date field using the Convert() function, as follows:

Convert(varchar(11), DATE_FLD,111)

The above shows the date as YYYY/MM/DD American customers are happy.

For my euro customer I need to show this date as DD/MM/YYYY Which I can do if I change the last parameter of Convert() from 111 to 103.

But how would you suggest I do it so that I don't have a custom version for one (euro) customer? All other dates of the application are ok based on the Globalization tag in the web.config. This has a setting of

uiCulture="en" culture="en-GB"

But the Convert() is a problem.

Any suggestions?

UPDATE. The above Convert() is used in the SQL Select as follows:

select 'Processed on ' + Convert(varchar(11), DATE_FLD,111) from MyFile

If there were a different function (other than Convert()) to show the date as a string, and that would respect the Globalization tag, it would resolve my issue.