DD-MON-YYYY format is not working
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.
Version (include the version you are using, if applicable):