Hi,
Sorry if I haven't searched enough to find a answer but can someone help me.
I put my application into production and all the dates seem to show the correct date minus 1 day. So instead of 1/6/2014 it shows 31/5/2014.
On local development PC the dates are correct and don't have this issue. All the functionality sorting filtering works but it just shows wrong date.
I use same browser IE11 to view both sites.
I am using following to format date field in grid.
c.Bound(r => r.Effective_Status_Date).Width(150).Format("{0:dd/MM/yyyy}")
I tested the grid on the production server with a date field with no formatting and it shows the correct date if there is no formatting applied.
Production server is https:// but everything else seems to work except this date formatting.
Please let me know if there is a better way to get format dd/mm/yyyy and not have this issue.
Thanks
Rob
Sorry if I haven't searched enough to find a answer but can someone help me.
I put my application into production and all the dates seem to show the correct date minus 1 day. So instead of 1/6/2014 it shows 31/5/2014.
On local development PC the dates are correct and don't have this issue. All the functionality sorting filtering works but it just shows wrong date.
I use same browser IE11 to view both sites.
I am using following to format date field in grid.
c.Bound(r => r.Effective_Status_Date).Width(150).Format("{0:dd/MM/yyyy}")
I tested the grid on the production server with a date field with no formatting and it shows the correct date if there is no formatting applied.
Production server is https:// but everything else seems to work except this date formatting.
Please let me know if there is a better way to get format dd/mm/yyyy and not have this issue.
Thanks
Rob
3 Answers, 1 is accepted
0
Robert
Top achievements
Rank 1
Rank 1
answered on 03 Jul 2014, 01:36 PM
OK it looks like a time zone difference on the server is causing the issue.
server is GMT + 1. Users are in GMT
23/06/2014 00:00:00 is database value
22/06/2014 23:00:00 is value displayed in grid
Is there are global setting to make sure the date is displayed on client correctly?
server is GMT + 1. Users are in GMT
23/06/2014 00:00:00 is database value
22/06/2014 23:00:00 is value displayed in grid
Is there are global setting to make sure the date is displayed on client correctly?
0
Hello Robert,
The scenario is discussed several times on the forums and over the internet. The only applicable solution (that we can suggest) and explanation why this happens is shared within this code library project:
http://www.telerik.com/support/code-library/using-utc-time-on-both-client-and-server-sides
Kind Regards,
Petur Subev
Telerik
The scenario is discussed several times on the forums and over the internet. The only applicable solution (that we can suggest) and explanation why this happens is shared within this code library project:
http://www.telerik.com/support/code-library/using-utc-time-on-both-client-and-server-sides
Kind Regards,
Petur Subev
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Robert
Top achievements
Rank 1
Rank 1
answered on 04 Jul 2014, 07:44 AM
I had seen this solution (from 2012) however this is a little disappointing I was hoping (in 2014) there was generic include file or reference that would check if it was a date field in the view and re-calculate it to UTC. My application was finished and I have over 300 (views and models) references to a date field in my application so I will need to update all of them with this code one at a time :(
Oh well I better get started.
Oh well I better get started.