Joe,
For a datetime value, subtracting the zero hour value of the day will
return the number of seconds.
That is
m.CurrentTimeInSeconds = DATETIME() - DTOT(DATE())
To use it in an Excel sheet as a time value, you must convert it to a
fraction of a day
m.ExcelCurrentTimeInSeconds = m.CurrentTim
There is no "Time only" variable type in VFP. Thus, you'll need to go with a
default date attached to your time portion.
I normally use the 1.1.2020 for that. As long as you always use the same
date part, your time calculations will be not affected from that additional
baggage.
In Excel you can j
I want to build a cursor of time fields for export to Excel. The DateTime
format allows a simple for next loop to increment the time value by a
specified number of seconds.
Is there a function that allows the extraction of the time portion of a
DateTime variable as a time value not as a string?
3 matches
Mail list logo