We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
24
Views
3
Comments
edited Oct 12, 2020 6:01PM in Reporting and Analytics for ERP 3 comments

Summary

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

Content

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.

Register

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