Question
Pegasystems Inc.
IN
Last activity: 11 Jul 2023 8:42 EDT
Localize yyyymmdd of date type to a text type property
As an example FromDate and ToDate are of Date type which is stored internally as yyyymmdd. This str value is not being localized. Are there any OOTB functions to localize the values?
@FormatDateTime() - Since its accepting a datetime type, Its returning a blank value
Tried pxparseDateTime- But again, date is not being localized. It's returning 20230710T155658.010 GMT.
Appreciate any help on this
Deepika
Aaseya IT Services Pvt LTD
IN
Pegasystems Inc.
IN
@PrakashDeep, I tried your way , but the dates are not being localized .
From date is 20230711 and To date is 20230724. On adding timestamp and format function its returning 20230711T020000.000 HAEC and 20230724T020000.000 HAEC.
Operator locale is fr_FR
Aaseya IT Services Pvt LTD
IN
@Deepika Sree
Can you please confirm what format exactly being expected for this operator locale. It is just the time zone , that needs to be considered or the display format also.
Because, few date display settings can be done at property level also without using any function
Pegasystems Inc.
IN
@PrakashDeep , Yeah for france locale it's dd/mm/yyyy . We need to customize the 20230711 to 11/07/2023.
Since FromDate/ToDate is of date type , timestamp needs to get added which enables the usage of @FormatDateTime(). But the only issue is it's not getting localized according to requestor's locale.
At the property level , I have configured it to text type with read only as date
Aaseya IT Services Pvt LTD
IN
@Deepika Sree
Is this what you need? I am able to get it with @FormatDateTime() function. Use Current Date instead of actual property
@Deepika Sree
You can append the Time string to end of your date property and then use it with @FormatDateTime() function.
For Example:
Param.FromDate = FromDate + "T000000.000 GMT"
Param.ToDate = ToDate + "T000000.000 GMT"
Then You can use the above two values in the @FormatDateTime()