Casting between String/Text and Dates

[keroleen]

Is is possible to convert a string/text type into a date (where it is YY-MMM-DD)

Can someone show me?

Thanks in advance.

[Kasracer]

yes

but it depends how the string or text holds the date.

more info please

[Edneeis]

It may also depend on what the date format is for your system, but in general Try using Date.Parse(mystring).

[keroleen]

I have two forms.
On the first form the user uses a DATETIMEPICKER and chooses a date. The date is then inserted into a TEXT field in the format of DD-MMM-YY (ie. 11-Nov-03).

This text value is then passed over to a second form.

In this second form I assign a new date type variable.
I think that I would need to do an assignment from the TEXT value that is passed into the 2nd form to the new date type variable?

It errors out on the assignment line.

Dim as dt as date

dt = tempdate
' where tempdate is the date that is passed in from the other form