Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date commands
Message
From
01/06/2005 14:57:46
 
 
To
01/06/2005 14:48:45
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01019078
Message ID:
01019085
Views:
21
>Hello,
>I have a date that I am reading from SQL Server, and I want to test to see if it is at least 30 minutes in the past. How would I do this?
IF SQLDateTime+(30*60)>=DATETIME()
  * Less than 30 minutes ago
ELSE
  * more than 30 minutes ago
ENDIF
Update:
This assumes that your PC and the server that stored the SQL data (and how the time was stored) are in sync with each other.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform