ESdat Forums
»
Forums
»
ESdat
»
Sample date/time format in Excel chemistry output
 Rank: Newbie
Groups: Registered
Posts: 0
Location: Melbourne, Aus
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 0
Location: Melbourne, Aus
|
In the chemistry output table/report, the sample_date_time seems to automatically format to "dd mm yyy" which omits any time data? Whilst we can't customise the excel template itself, is it possible to control the format of this via the database field? Or can we only display the time data by manually formatting the excel output after export?
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
The Sample Date-Time in the Chemistry Output Tables defaults to your regional settings (under control panel on your PC). It is correct that you can't specify a different date format via the template as the location of the Sample_Date-Time will be inconsistent, depending on your export selections. Only the date component is shown in the chemistry output tables. The time component is exported but the cell formatting is such that it isn't displayed. We will address this issue so that the formatting shows the time component, where present. In the interim it needs to be fixed by changing the cell formatting in Excel using the standard method (Format Cells). This can only be done post-export. This issue only effects Chemistry Output Tables, not other exports to Excel.
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Sample date/time format in Excel chemistry output
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.