This content has been marked as final. Show 2 replies
I have the following fields in my database:
ID History (memo datatype in access db)
|43204000||02/01/2006 09:05 J1 Inquiry Received|
12/01/2006 13:13 J1 Pricing Completed
12/01/2006 13:13 J1 Quotation Produced - Ref XXXXX
|43205000||02/01/2006 09:07 J1 Inquiry Received|
07/01/2006 10:28 J1 Pricing Completed
07/01/2006 10:29 J1 Quotation Produced - Ref XXXXXX
05/02/2006 18:19 SU Order Received
06/03/2006 09:38 JL Shipment Recorded #12470
I want to extract the dates for each status of order in the History for every ID on load.
I tired a lot to split using trim, subfield and chr(13) but it doesnot seem to work.
It would be great if anyone could help me out.Thanks a lot in advance.