Convert Text to Date

[Guest]

What is the most efficient way to convert a text string in the form of
20060218 to a short date? Thanks!

 

[Guest]

Assuming that the field always have the same formt
yyyymmdd

Try
cvdate(format(FieldName,"####/##/##"))

 

[Marshall Barton]

What is the most efficient way to convert a text string in the form of
20060218 to a short date? Thanks!

Short date is a format, which is irrelevant to the value.

To get a date value from that kind of string:

DateSerial(Left(txtstr,4), Mid(txtstr, 5,2), Right(txtstr,2)

To format the date value set the Format property of the text
box that you're using to display the value.

 

[Guest]

Thank you!

Assuming that the field always have the same formt
yyyymmdd

Try
cvdate(format(FieldName,"####/##/##"))