Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pulling Records In A Scheduler
Message
From
08/04/2008 14:11:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01308890
Message ID:
01309107
Views:
11
What about this? (just off the top of my head -- not sure if this will work the way you want)
ltNow = DATETIME()
lnYr = YEAR(m.ltNow)
lnMo = MONTH(m.ltNow)
lnDy = DAY(m.ltNow)
lnDiff = 60    && Adjust to whatever you need
SELECT att_pk;
	FROM AutoTask;
	WHERE (m.ltNow-DATETIME(m.lnYr,m.lnMo,m.lnDy,att_hour,att_min))<=m.lnDiff;
	INTO CURSOR crsrAutoTasks
(the above code will need a few tweaks to work correctly for cases where the hour and date are close to the end of the day)
Previous
Reply
Map
View

Click here to load this message in the networking platform