Skip to main content
Contact a Moderator

Question

2
Replies
1388
Views
 Chakravorty Amit (AMITTUTUN) Capgemini
Capgemini
SE
AMITTUTUN Member since 2011 67 posts
Capgemini
Posted: June 28, 2017
Last activity: July 25, 2017
Posted: 28 Jun 2017 7:40 EDT
Last activity: 25 Jul 2017 20:03 EDT
Closed

Scheduled report is showing GMT time not local time when output is taken in excel

Hi, Scheduled report is showing GMT time not local time when output is taken in excel. Is there any way to fix this issue.

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 3 Jul 2017 4:17 EDT
Rincy Rappai (RINCYRAPPAI) PEGA Principal Software Engineer DevSecOps, Application Security
Pegasystems Inc.
IN

Hello Amit, 

Thanks for posting your query in PSC :)

Can set to a date property like below and use the same in report?

@FormatDateTime(@CurrentDateTime(), "yyyyMMdd'T'HHmmss.SSS", "EST5EDT", "en-US") + " GMT"

If it does not work, share the screenshot of the report displaying to datetime property. This is to see if you are using the property directly or referring a function.

Regards,

Rincy

 
Posted: 4 years ago
Posted: 25 Jul 2017 20:03 EDT
Susan Liu (SusanLiu_GCS) PEGA Senior Principal Engineer, Technical Support, Runtime Engine
Pegasystems Inc.
US

Hi Amit, 

Pega always maintains DateTime properties in GMT timezone internally.
To convert to any other timezone, FormatDateTime function is provided.

example:

@(Pega-RULES:DateTime).FormatDateTime(@DateTime.CurrentDateTime(),"yyyy-MM-dd'T'hh:MM:ss", "EST", "en_US")

Please note that the output of @FormatDateTime is a String (a Text property) not a DateTime property.

Check below pdn article:

https://community.pega.com/support/support-articles/how-get-timestamp-value-est

Thanks,

Susan

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice