cancel
Showing results for 
Search instead for 
Did you mean: 

How to handle backoffice timezone issue?

Former Member
0 Kudos

1) When a user is in IST and the server is at EST,if the user enters date from backoffice create wizard as e.g. March 1st 10 AM 2017, in db it is saved as Feb 28th 23:30 EST.how to handle these in backoffice?

2)When a user is in EST and the server is also in EST, if he enters date as March 24, 00:00 :00 AM EST 2017,in db it is saved March 24th 1:00:00 AM 2017 EDT.how to handle this kind of daylight time situation?

3)In above situation , you will find list view timezone is EDT and editor Area timezone is EST.So the user dont know which value is stored in db?

Please help me in how to handle these kind of server-user timezone issues.Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

former_member632755
Active Contributor
0 Kudos

Hi,

as mentioned in the other thread tou created on the topic in databse you always have timestamp stored. Timestamps are universal, they denote a moment in time, and are not related to TimzeZones at all. TimeZone is used for user's convenience. The user understands his time zone and therefore the editor by default uses the user's time zone.

See the Default Date Editor's documentation for examples of how to configure the editor to give choice of the time zone to the user.

The example configuration from the documentation:

 <editorArea:attribute qualifier="onlineDate">
     <editorArea:editor-parameter>
         <editorArea:name>timeZoneReadOnly</editorArea:name>
         <editorArea:value>false</editorArea:value>    
     </editorArea:editor-parameter>                        
     <editorArea:editor-parameter>    
         <editorArea:name>selectedTimeZone</editorArea:name>
         <editorArea:value>GMT+1</editorArea:value>
     </editorArea:editor-parameter>                        
     <editorArea:editor-parameter>
         <editorArea:name>displayedTimeZones</editorArea:name>
         <editorArea:value>GMT-2,GMT-1,GMT+0,GMT+1,GMT+2</editorArea:value>
     </editorArea:editor-parameter>
 </editorArea:attribute>

should be enough to understand the concept.

Cheers, Wojtek

Answers (0)