Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Increment time() by 1 minute
Message
From
08/06/2005 04:21:40
 
 
To
07/06/2005 12:15:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01020951
Message ID:
01021259
Views:
17
>>That works great Sergey, if I'm working with a datetime() value. In my case the value I want to increment by one minute is a time() value.

The problem is TIME() does not return a "time" value, there is no such data type in VFP, TIME() returns a Character string.

If you want a time type of value you have to use DATETIME() which is actualy a type of time variable.

or you can work directly with SECONDS() a numeric variable.
x = SECONDS() + 60
lcTime = TRANSFORM(INT(x/3600),"@L 99")+":"+TRANSFORM(INT((x%3600)/60),"@L 99")+":"+TRANSFORM(x%60,"@L 99")
(Sample code not fully tested)
Previous
Reply
Map
View

Click here to load this message in the networking platform