>Who can help me?
>I have a table 'custdetails' with the following fields: Shipdate,customerid.
>I want to fill grid with how many NEW customer I had every day.
>I rununing the following syntax:
select * from custdetails order by shipdate into cursor tmp1 nofilter
>select * from tmp1 group by customerid into cursor tmp2 nofilter
>Select shipdate,count(customerid) from tmp2
>My problem is that I get the late shipdate not the first (if person has shipdate for today and for yesterday he will be counted as yesterday).
>What can I do?
>Thank you for help
>Chaim
Do you mean you want to count customers who have a Shipdate = Today ?
select count(distinct customerid) from custdetails where ShipDate = date()
Cetin