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
n Excel you can just display the time part.
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox Im Auftrag von Joe Yoder
Gesendet: Montag, 26. Juli 2021 18:36
An: profoxt...@leafe.com
Betreff: Time variables
I want to build a cursor of time fields for export to Excel. The DateTime
format allo
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
