Converting Text field to Date

[elaineva]

Can a text field be converted to a date field? I would need to do this in the query - not change the field type in the table. Help please!

 

[KenReay]

Hi

X:CDate(txtDate)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[elaineva]

Thanks Ken

Not having any luck with this - get #error in the field - not sure what I'm doing wrong....

nudate:cdate([date_dlv])

date_dlv is the text field I want to convert to a date field.

 

[elaineva]

got it working - thanks.