how to convert date in ddmmyy format

[Former Member]

dear all

i am passling the date like that

  Dim oDelDate As SAPbouiCOM.EditText
oDelDate=oForm.Items.Item("11").Specific.Value
 osubForm.Items.Item("12").Specific.Value = oDelDate.Value

but it passel the date like

20111014

i need to show that

like this

14/10/11

how it possible

plz help

[Former Member · Accepted solution]

Hi Kishor,

Try This.........

                 Dim oedit As SAPbouiCOM.EditText
                 oedit = oform.Items.Item("10").Specific
                Dim for_date As String
                for_date = oedit.Value
                Dim today_date_str As String
                today_date_str = for_date.Substring(6, 2) + "/" + for_date.Substring(4, 2) + "/" + for_date.Substring(0, 4)
                MessageBox.Show(today_date_str)

Thanks

Shafi

[Former Member]

cdate(oForm.Items.Item("11").Specific.Value).ToString("yyyyMMdd")