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

How to Display Date and Time as per User Local Settings in Excel Template

Accepted answer
edited Oct 12, 2020 6:01PM in Reporting and Analytics for ERP 4 comments


We need to display the Date and Time as per the User Regional Settings. We need to know how to use the XDODEFDATE and XDODEFTIME in Excel Template


Our Requirement is to display the Current Date and Time based on the setting in the Set Preferences > Regional . In the RTF Template we are able to use the XDODEFDATE and XDODEFTIME. We are getting the excepted results in the Output.

We need to do the same code in Excel based Template. We are unable to achieve this. Can anyone specify if this option is supported in Excel Template. If not, what are the workarounds available ?

Howdy, Stranger!

Log In

To view full details, sign in.


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