Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
DD-MON-YYYY format is not working — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DD-MON-YYYY format is not working

Received Response
285
Views
3
Comments
in Reporting and Analytics for HCM 3 comments

Summary:

We have a requirement to display the date format as "DD-MON-YYYY'. Ex. 14-FEB-2025.

We are using RTF Template. In the query I am not doing any kind of formatting, just fetching the date field from the table.

and in RTF Template on the date field making the field type as Date and format as "dd-MMM-yy".

Here the issue is the date output is getting displayed one day before.

Example: Date In Data Model's Output: 14-Feb-2025 but in Report's output it is "13-Feb-2025"

Never faced such challenges. Any input would be really helpful.


Content (required):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!