on 09-06-2018 1:20 AM
Hi,
I've been asked to export certain metadata properties for our PDM data models out of PD so they can be loaded into an MS Excel workbook.
I assumed this would be easy to accomplish by simply setting up a List Report with all the metadata properties I need. However I have issues getting the 2 date time metadata properties, Entity "Creation Date" and Entity "Modification Date", out of PD in a recognized date format.
Is there anyway to modify the date format for List Reports? Or possibly change the default date format?
Current Default Date Format in List Reports: Month-DD-YY HH:MM:SS (i.e. MS Excel does not recognize this format as valid date)
Preferred Date Format: MM-DD-YYYY HH:MM:SS (or any MS recognized format).
Thanks!
I think it uses long date (and time) format set up in your operating system. Change it in windows and try the list report again.
Ondrej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.