Thursday, April 20, 2023

Retaining Date Format in Excel Output from RTF template

Sometimes we face issue in getting correct date format in XLS output generated using RTF template.

We can retain format selected in Data Template query and use same in XLS output using below syntax 

Double Click on RTF field value

It will open "Text Form Field Options" window , click on "Add Help Text" button

Use below to force literal format 

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?ACCOUNTING_DATE?></fo:bidi-override>


Thanks!


No comments:

Post a Comment