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 just display the time part.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Joe Yoder Gesendet: Montag, 26. Juli 2021 18:36 An: profoxtech@leafe.com Betreff: Time variables
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? It seems one could pull out the hours and minutes as characters and convert them to time via CTOT but this results in a DateTime result with an embedded date.
Thanks in advance,
Joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]