The strange things is that I started developing the application in April and all the April dates are showing as being correctly formatted to UK format.
however since start of May 2016, All the May Dates are reverting to US format and showing as March Dates in the application.
I am not sure if I have changed something in hind sight. nevertheless, I am not sure how to solve this problem.
below are the codes being used:
in SQL SELECT code, I am using the Format Statement
Expand|Select|Wrap|Line Numbers
- ... Format(InvoiceDate, 'DD/MM/YYYY') AS InvDate...
Expand|Select|Wrap|Line Numbers
- theGrid.Columns[7].HeaderText = "Date";
- theGrid.Columns[7].Width = 80;
- theGrid.Columns[7].ValueType = typeof(DateTime);
All help is appreciated.