Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Filter
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00499800
Message ID:
00500072
Views:
20
Its not often I can out do Larry <g>:

LPARAMETER tdTarget

m.tdTarget = IIF(VARTYPE(m.tdTarget) = "D" AND NOT EMPTY(m.tdTarget), tdTarget, CTOD("04/01/2001")

SELECT * ;
FROM Stest St1 ;
WHERE code + TRANSFORM(Date) IN ;
(SELECT code + TRANSFORM(MIN(Date)) ;
FROM Stest S2 ;
GROUP BY Code ;
HAVING MONTH(MIN(SDate)) = m.tdTarget)

Regards,
Thom C.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform