Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sudheer Prakash TV (sudheerprakash)
TCS
Associate Consltant
TCS
IN
sudheerprakash Member since 2016 30 posts
TCS
Posted: Dec 2, 2020
Last activity: Apr 18, 2021
Posted: 2 Dec 2020 13:10 EST
Last activity: 18 Apr 2021 5:58 EDT
Closed

concatenate date and time into datetime

from service we are getting time and date separate values as below.

Date : 2018-08-02 and 20180802

Time : 13:52:00 and 1352

now we need to display it in UI as m/d/yy h:mm am/pm. how to achieve this.

***Edited by Moderator: Pooja Gadige to add platform capability tag***
To see attachments, please log in.
Pega Platform 8.4.3
User Experience

Posted: 5 years ago
Posted: 3 Dec 2020 20:55 EST
Braam Smith (BraamSmithCLSA)
PEGA
Partner Success Tech Lead - APAC
Pegasystems Inc.
AU

@sudheerp2695  

You will need to know what timezone the time is in before you can complete this.

Assuming the time is in GMT:

  • 20180802 and 1352 are very close to how Pega natively stores its timestamps. Turn this into a single string "20180802T135200.000 GMT" and set this value to a property of type DateTime in your Pega page.
  • When you get the 2018-08-02 and 13:52:00 pairing, this is better subjected to a custom Function that you configure, which returns output similar to the "20180802T135200.000 GMT" format above, which you would against set to the a DateTime property in your Pega application. See if this post gets you moving in the right direction: https://collaborate.pega.com/question/there-any-ootb-function-validate-2020-05-21t183000z-datetime-format-and-convert-pega 

It is important to know the timezone of the time you receive as Pega will want to manage it in the GMT timezone.

Once on the clipboard as a Pega DateTime property, a field on your Section rule bound to the Date Time property provides options on the date/time format to display that timestamp as. Pega will also display the date/time according to the timezone of the current user, as per the TimeZone value on their Operator ID.

Using your proposed format, a user in US East Coast would see the time shown as:

8/2/18 9:52 am

Show More

@sudheerp2695  

You will need to know what timezone the time is in before you can complete this.

Assuming the time is in GMT:

  • 20180802 and 1352 are very close to how Pega natively stores its timestamps. Turn this into a single string "20180802T135200.000 GMT" and set this value to a property of type DateTime in your Pega page.
  • When you get the 2018-08-02 and 13:52:00 pairing, this is better subjected to a custom Function that you configure, which returns output similar to the "20180802T135200.000 GMT" format above, which you would against set to the a DateTime property in your Pega application. See if this post gets you moving in the right direction: https://collaborate.pega.com/question/there-any-ootb-function-validate-2020-05-21t183000z-datetime-format-and-convert-pega 

It is important to know the timezone of the time you receive as Pega will want to manage it in the GMT timezone.

Once on the clipboard as a Pega DateTime property, a field on your Section rule bound to the Date Time property provides options on the date/time format to display that timestamp as. Pega will also display the date/time according to the timezone of the current user, as per the TimeZone value on their Operator ID.

Using your proposed format, a user in US East Coast would see the time shown as:

8/2/18 9:52 am

... as in August they are 4 hours behind GMT.

Show Less
To see attachments, please log in.
Posted: 5 years ago
Posted: 18 Apr 2021 5:58 EDT
Lenka Rolinek (rolil)
PEGA
Lead System Architect
Pegasystems Inc.
AU

@BraamSmithCLSA

 

What if we want to get timestamp in GMT where specified/known date and time are based operator time zone ?

Date : 20180802

Time :1352

Is there a function to get time zone offset (in hours) based (operator) time zone, e.g. Australia/NSW ?

Or is this best to implement as function ?

To see attachments, please log in.

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