Switch to full style
Use this forum to post questions relating to WinGate, feature requests, technical or configuration problems
Post a reply

Date format in linked History.dbf

Mar 17 04 1:44 am

I've linked the history.dbf file into MS Access 97.

Although all the other fields are fine, I can't seem to get the date field to view correctly.

For example in the text export of the history file one line reads "16-Mar 12:34:09" but in the history.dbf file it is showing up as "1079440449".

Does anyone know how I can view the date field correctly using MS Access 97?

Mar 17 04 11:18 am

The date is worked out as the number of seconds since midnight, January 1, 1970. (Standard C time_t) You'll need to use an appropriate conversion / format to convert it.
Post a reply