Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to count different/unique dates?
Message
From
24/05/2004 23:44:12
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
 
To
24/05/2004 23:33:02
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00906785
Message ID:
00906787
Views:
10
SELECT DISTINCT mydbf.myfield AS uniquedate ;
    FROM mydbf ;
    ORDER BY mydbf.myfield ;
    INTO CURSOR mycursor
or
SELECT mydbf.myfield, COUNT(*) AS totalrecords ;
    FROM mydbf ;
    GROUP BY mydbf.myfield ;
    ORDER BY mydbf.myfield ;
    INTO CURSOR mycursor
>Dear Experts
>
>I have a table that has only one field type date which contains data as follows
>
>20/03/2002
>20/03/2002
>20/05/2003
>22/05/2003
>22/05/2004
>25/05/2004
>25/05/2004
>26/05/2004
>
>Total records/dates are 8 but the number of different dates is 6.How is it possible to find out different dates in a field programatically.
>
>Please help
Previous
Reply
Map
View

Click here to load this message in the networking platform