Skip to content
Ask A Question
  • There are no suggestions because the search field is empty.

Customizing the DateTime format with the LGH File Inspector

How can the export format of the DateTime string be modified when querying the data in the UI, exporting the data to Excel, and/or exporting the data to a CSV file, when using the LGH File Inspector?

Starting with LGH File Inspector version 1.4.2.0, a QueryDateTimeFormat field has been added to the LGHFileInspector.exe.config file. You can customize the Date and Time Format. Modifying this setting will change how the datetime format is presented in the UI, and change the format with which the datetime field is exported to CSV and/or Excel.
 
In the below example we will be making them appear as 'dd/MM/yyyy hh:mm:ss' instead of the default of 'MM/dd/yyyy hh:mm:ss'
 
The location of the config file will depend if you installed LGH File Inspector for 'All Users' or 'This User Only'
  • All Users - C:\Program Files (x86)\Software Toolbox\LGHFileInspector
  • This User Only - C:\Users\[USERNAME]\AppData\Local\Programs\Software Toolbox\LGHFileInspector

When you open the config file you will want to navigate towards the bottom of the file. You will find the QueryDateTimeFormat entry like below. 

Original:

<setting name="QueryDateTimeFormat" serializeAs="String">
                <value />

Replace With:

<setting name="QueryDateTimeFormat" serializeAs="String">
               <value>dd/MM/yyyy hh:mm:ss </value>

To apply the changes, save the config file and restart LGH File Inspector.
For a complete list of available parameters reference DateTime Format Strings