Question
Estes Express Lines, Inc.
IN
Last activity: 18 Apr 2021 5:58 EDT
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.
Pegasystems Inc.
AU
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
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.
Pegasystems Inc.
AU
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 ?