Export CSV - DiveDate not showing time

Discussions about Diving Log 6.0 - questions and hints
Post Reply
reefhound
Posts: 61
Joined: Mon May 07, 2007 01:10

Export CSV - DiveDate not showing time

Post by reefhound »

When I export dives as CSV and include the DiveDate column, it exports as "6/24/1998 12:00:00 AM" where time is always "12:00:00 AM". Is this a known issue or limitation, or pilot error on my part? I'm using the latest update.
divinglog
Site Admin
Posts: 5844
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Export CSV - DiveDate not showing time

Post by divinglog »

Yes, looks like this should be changed. Divetime is stored in a separate column "Entrytime", but this is exported with a 1899 date. So I should merge these two columns for the export or remove the zero time and 1899 date. But merging would be probably better.
reefhound
Posts: 61
Joined: Mon May 07, 2007 01:10

Re: Export CSV - DiveDate not showing time

Post by reefhound »

Thanks a lot. I overlooked the column EntryTime. A single column with correct date and time would be nice but this information does allow me to get at the data I need. I'm wanting to create a Python script to read the CreateDate of underwater media files and match them up with the Date and Time of the logged dives so that I can set metadata in the media file with columns in the logbook like dive site.
Post Reply