>Hi There,
>
>I was wondering if you could help me.
>
>I have a table called "Username" and in that table i am a field called "DOB" which holds the date of birth of all the users. I was wondering wat is the syntax i should use in Command runner to retrieve a particular date from that table. Thanx for the help in advance.

Bilal

If you're in the command window you can enter a valid date like:

ldTestDate = CTOD("01/04/1995")

then retrieve the date as:

Select * from UserName where DOB = ldTestDate

or

Select * from UserName where DOB = CTOD("01/04/1995")

This is using SQL select. It takes more commands, and a pprogram loop, to retrive via native VFP xBase code. Your query is too brief to determine what you want.

Terry