WinGate Forums

by **celeiro** » Mar 27 04 11:53 pm

How convert the format of starttime in the HISTORY to dd/mm/yy?, thanks. Sorry by my english.

by **Pascal** » Mar 28 04 12:13 am

StartTime is calculated from a time_t value (Standard C) It is the number of seconds that have elapsed since 1 January, 1970. I can't remember the conversion offhand now, but I have an appropriate formula in the office.

by **celeiro** » Mar 30 04 3:54 am

thanks, can you say me the formula when you have time?

by **Pascal** » Mar 30 04 2:38 pm

What app do you want to use it in ? (Easiest to do the conversion formula for that then ... )

by **celeiro** » Mar 30 04 6:58 pm

yes, i want the easiest formula. Thanks

by **Pascal** » Mar 30 04 8:47 pm

Well, if you want it for Excell, I can work it out in Excell. If you want it for Access, I can work it out for Access. Etc.

Hence - which application do you want it for ? Or is this for custom software ?

In which case, it's basically a question of dividing by the number of seconds per year, working with fractions, etc. until you come up with an answer.

by **celeiro** » Mar 30 04 9:40 pm

ah!, ok; for excel please.

WinGate Forums

StartTime

StartTime

Who is online