FiveTech Software tech support forums

... It seems that your backup utility is more for an office environment. I am working with hotels and restaurants. If someone maybe stops working at midnight or later he won’t answer questions the backup program asks. If I want a backup it must run automatically. My problem at the moment is the management ...

... blank records with adjusted time Endif The adjusted time just adds 4 seconds each time. Thus giving me what I need. But when the time jumps over midnight my above code will not work.

... adding files Endif Else // Assuming dates are entered in ascending order. // We have to calculate seconds elapsed from last day's time until // midnight and add the seconds elapsed from 2nd time reading. If ((86399 - First_Rec_In_File2>Time) + Last_Rec_In_File1>Time) < 4 ** stop adding ...

... // focus again Endcase return .t. /*** * TimeAsSeconds( <cTime> ) --> nSeconds * Convert a time string to number of seconds from midnight */ FUNCTION TimeAsSeconds( cTime ) RETURN VAL(cTime) * 3600 + VAL(SUBSTR(cTime, 4)) * 60 +; VAL(SUBSTR(cTime, 7)) **************************************************************** ...

Hi Everybody,

Does anyone know of a formula to calculate a Date and Time based on elapsed time in seconds from a certain date.

ie: The date is Jan 01 1990, Elapsed time in seconds from midnight of that date would be 572778954.

How would I get the date time of the above?

... high order 4 bytes are an integer containing a Julian date, and the low order 4 bytes are internally stored as the number of milliseconds since midnight. If using the Advantage CA-Visual Objects RDDs, this is a string type. and, I have interest in MONEY type too, but I get error when I try to ...

Dale,

I know, I can be a real PITA.

Just try using the file time. Unless users will be working across midnight you don't need to use the date too, although that would be safer.

I would use a longer interval also, 5 seconds maybe. That will also reduce the traffic considerably over 1 second.

James