Form - Text Box - Return valid date

[DaBuzz]

I am slowly migrating from fp2.6 to vfp.
The road block that I've encountered is on forms, using a field to input the date in 01/01/2002 format but then passing that format to a variable for a query in the strictdate format of {^2002-01-01}.

Are there settings within the properties that will format it correctly or do I need to convert it. I've tried to find a simple answer and seem to be missing it.

Appreciate the help!

 

[ramani]

HI
1. You can specify the
TextBox.StrictDateEntry = 1 && strict - that is default

2. see also... SET STRICTDATE TO

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[DaBuzz]

I've tried that - It is something to do with the form (me)properly transferring the date.

I set the variable prior to the form gvBdate={^2001-01-01}
?gvbdate displays 01/01/2001

I run the form
in the form I enter in 12/31/2004
?gvbdate displays 12/31/2004

but the query says operator mismatch
The query has C.bdate>=gvbdate
The field type had been date, I've tried datetime.