Display of time does not render as per Operator Timezone
HI,
I am facing issues with datetime value. The DateOfBirth is saved in datetime format in DB & fetched on property of type DateTime. The value in DB has the time part as 00. While fetching the data the value is converted to GMT & correctly reduces it by an hour(timezone difference). But for a few records the time part is 00 and not decreased by 1 hour. Does anyone know about this issue? Also, while displaying it should automatically add 1 hour owing to my Europe/Dublin timezone in operator ID but it is not doing this & showing a day less as the DoB! Any help/input will be highly appreciated!!
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
Hi Tanul,
Try changing the Data Type of the Property you are using to capture the DOB to the "Date" data type instead of using DateTime.
Regards,
Henry
Pega Academy
Aaseya IT Services Pvt Ltd
IN
Thanks Henry for your reply. Even if the property is of type 'Date' - Pega fetches it in DateTime format in GMT zone(decreases by one hour) and then clips off the time part...As a result the value is a day less than the correct Date.
Pegasystems Inc.
US
Sorry this did not resolve your issue. In order to resolve the issue that you are experiencing a thorough review of all of the factors contributing to the issue is required. Please submit a Service Request (SR) so that one of our Customer Support technicians can work with you on this. You can do so by contacting Pegasystems Global Technical Support through My Support Portal.
Thanks,
Sean
Pega Academy
Infosys Limited
US
We had a similar issue for EST where the Date was stored correctly, but the time as 00:00:00. When this was displayed on UI, it always showed one day prior. That was obvious because of the fact that anything minus "00:00:00" time was always going to be previous date. We implemented a workaround by adding 6 hours to the GMT date. This is to ensure that when 4 hours (during EDT) or 5 hours (during EST) were subtracted internally to render the value, the date still remained unaffected. If you are fetching dates from an external service call, do this within the activity itself. If this is from a ListView, I would recommend applying a DisplayFormat that takes care of this addition of hours appropriately.
Aaseya IT Services Pvt Ltd
IN
Well we did find the solution to it...THe issue was difference between the Timezone in operator Id & Application Server...we had Dublin as timezone for Operator & BST was the timezone of App Server - but what caused confusion was some dates were being rendered correctly while some with one hour less...the issue was because Ireland uses Irish Standard Time(UTC+01:00) in summer & GMT (UTC+00:00) in winter... so the dates falling in different seasons were being rendered accordingly!! I think it is an important learning to understand the TimeZone working of the region the Application is supposed to serve...
Regards,
Tanul Thanvi.