How to extract date

[alisaif]

Hi,

How can I extract the last supply date from sales transaction files.

Dbf fields are:

1. sino
2. invdate
3. icode
4.
5.
6.....

I want icode and invdate(Date of supply).

Thanks

Saif

 

[EzLogic]

select icode,max(invDate) as LastInvDate from yourTable group by icode into cursor Somecursor
sele somecursor
brow


Ez Logic
Michigan

 

[alisaif]

Thanks, I did check it but I hope it will work.

Saif

 

[alisaif]

Hi,

Please go through the attached image. I want four columns; Icode, Invdate, Quantity and Value.

But only the highlighted value.

Thanks

Saif

 

[JRB-Bldr]

Please go through the attached image. I want four columns; Icode, Invdate, Quantity and Value.

Ez Logic pretty much already gave you the code or at least the approach.

Rather than waiting for someone to GIVE YOU THE CODE, what have you tried?
And what were the results?

Good Luck,
JRB-Bldr