Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies replies
    2
  • Subscribers subscribers
    4
  • Views views
    311
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Date format is changing after exporting the report from AM Browser

SupportTools

Dears, 

We have created the view and when we view the asset details via browser view its showing as expected. but when we export the data into the excel sheet format is changing only for the date after 2029.

example we have a column called hardware EOSL and its having data like 8-AUG-30, 7-SEP-29, 3-JUN-31,4-AUG-31. when downloaded into to excel its showing as 8/8/1930,7/9/2029,3/6/1931,4/8/1931 instead of 2030,2031.

please suggest.

Thank you.

Regards,

Indra

  • 0

    "AM Browser" is not my area of expertise, however, confirm whether this displays dates based on computer regional settings.  Also, confirm actual values regardless of regional settings.  One would think if truly 2030 / 2031, then Excel is the culprit and then I digress as to why Excel does not display in same format.

  • 0 in reply to 

    Actually it is excel issue only, but customer is not ready to agree and they still want the data in their wishing format. so seeking the support from MF support as well, meanwhile checking for alternatives.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.