>
>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.

ldTestDate = {01/04/1995}
* Even better
ldTestDate = {^1995/04/01}