Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to extract date

Status
Not open for further replies.

alisaif

ISP
Apr 6, 2013
418
AE
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
 
select icode,max(invDate) as LastInvDate from yourTable group by icode into cursor Somecursor
sele somecursor
brow


Ez Logic
Michigan
 
Thanks, I did check it but I hope it will work.

Saif
 
Hi,

tmpsi_abia2l.png


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

But only the highlighted value.

Thanks

Saif
 
Saif said:
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top