Info On How To Use A Date As Part Of An Index 1

[drosenkranz]

New To VFP from VB. I want to create an index based upon a "Case Number" and a "Date Completed" field. I want the records for this Case to appear in chronological order on the form. I'm using the data environment with the table name, a set filter condition with the case_no = gc_case_no, and I want to set the "Order" to an index in the table.

I tried using the following to create the index.

Case_No C 10
date_comp D 8

Case_No + date_comp

Case_No + Year(date_comp) + month(date_comp) day(date_comp)

but still had errors associated with the combination of dates and characters.

1) Will a blank date field a problem?

2) Could you tell me how to create the index in the container using a date as part of index's formula?

Thanks

 

[foxdev]

Case_No + DTOS(date_comp)
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[dgrewe]

or case_no +DTOC(date_comp , 1) David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644