[RESOLVED] hOW TO convert date

[kamakshi]

for example i have Sep10
i need to change it 09/10/2009
could you help me

[Siddharth Rout]

Where is Sep10 stored and how is it stored? Is it stored as date or string? Are you doing it in Excel?

[westconn1]

sep10 is always a string

cdate("sep 10"), will give the result you want

cdate("sep10"), will give type mismatch error

[kamakshi]

Sep.10 as string
and convert into date as mm//dd/yyyy

[Siddharth Rout]

kamakshi, since it is a string, you need to be clear...

Is it

"Sep.10"
"Sep10" or
"Sep 10" ?

[kamakshi]

text is Sept.10

[Siddharth Rout]

Try this...

Sub Sample()
    Dim strDate As String
    
    strDate = "Sep.10"
    
    strDate = Replace(strDate, ".", " ")
    
    'MsgBox Format(strDate, "dd/mm/yyyy")
    MsgBox Format(strDate, "dd/mm") & "/2009"
End Sub