Coversion text to date

Hi Nadia

Thank you for your question.

The trick here is to create 2 variables. A string variable and a date variable. Set the string variable equal to your text field value, and then set that equal to the date variable using the Cdate function which converts the text string into a date

The following code gives an example of this. (It is taken from Excel VBA as this is easier to demo, but you can simply replace the literal string with the relevant field from the recordset.)

Sub DateConv()

    Dim strDate As String

    Dim dteDate As Date    

    

    strDate = "14/2/1964"    'Replace with relevant field

    dteDate = CDate(strDate) 

        

    Range("c1").Value = dteDate

    



End Sub

Hi Nadia,

Did you manage to send your workbook to Stephen?

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich