[Pansophy] Datamine Excel Report Request

[Tiffany Ganey]

Good morning Pansophy Team,

I would like to request that the excel reports from Datamining include the time for timestamp fields.  Since I frequently am only interested in the date (not including time), it would be nice to have the option to select "date only" or "timestamp", or to have separate excel columns for "date only" and "timestamp" so that I can choose which column of data I need to look at.

I am looking to calculate the time between the HPREndTime (SNSPPU-CHEM-CAV-HPR) and the FinalAssyDate (SNSPPU-CLNRM-CAV-ASSY2).  I did an excel export of the VARGRID for both travelers (SNSPPU-CHEM-CAV-HPR and SNSPPU-CLNRM-CAV-ASSY) but the report only provides the date; it does not include the time so I cannot calculate the time (hours: minutes) between these two events.  I tried using the USER DEFINED query as well, but it also only provided the date.

Tiffany Ganey

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210625/fb30ecde/attachment.html>