ExcelTdmExport Date Format

[JoshRew]

Is it possible to change the date format of ExcelTdmExport (Save as --> ExcelTDM)?

For some reason, the file opens with a "custom" date format of "dd/mm/yyyy hh:mm:ss.000 AM/PM" (European?) for all absolute timestamp channel values, including properties:

This appears to be ignoring the DIAdem configuration, Windows Region settings, etc.

This does not happen when saving as a TDM and using the TDM Importer, but that is much less straightforward to automate an export to Excel for.  Is this configurable, or a bug?

-Josh

[Brad_Turpin]

Hi Josh,

I asked Walter, and Walter asked R&D, and the answer back is that this is currently not configurable.  We are now discussing best options to potentially improve this behavior.  Sorry about the delay and thanks for the feedback.  I had never noticed the European datetime format in those converted files.  I mainly use the Excel TDM Addin, and I just assumed everything would be the same with the DataPlugin that was designed to reproduce that schema in Excel.

Brad Turpin

Principal Technical Support Engineer

NI

[Brad_Turpin]

Hi Josh,

No progress on this issue in DIAdem 2021, as far as I can tell. 😞

Just FYI,

Brad Turpin

Principal Technical Support Engineer

NI