Date Formatting

Question

User-280752524 posted

Hi Guys,

Need you idea on this one.. I have a textbox then i need to convert the text that the user input in that text box into date..

For example the user input :1/2/2005 then i need to convert this into : 01/02/2005

anyone knows how to convert this.

I have this code but unfortunatley the conversation to the format that i need is wrong..

     Dim podate As Date
        podate = Format(CDate(txtdate.Text.ToString), "MM/dd/yy")

It only gives me : 1/2/2005 
I need is : 01/02/2005


Pls help me.

Thanks and Regards.
Annir

Answer 1

User-1636183269 posted

Dim podate As Date
        podate = Format(CDate(txtdate.Text.ToString("00/00/2000")), "MM/dd/yy") 

I have not tested but sure it will work

Answer 2

User-280752524 posted

Hi,

Thanks for the quick reply. I try your code but it gives me an error:

unable to cast object of type 'System.String' to type 'System.IFormatProvide'

Thanks.

Annir

Answer 3

User1485408165 posted

To get the 0's in your output strings try:

Dim culture = CultureInfo.CurrentCulture

Date.ParseExact(txtdate.Text, "mm/dd/yyyy", culture).ToString("mm/dd/yyyy")

Answer 4

User-280752524 posted

Hi,

Thanks for the reply, I try to use this but it gives me an error at Dim culture = CultureInfo.CurrentCulture saying that the CultureInfo is not yet declared.. Is culture mas be declared as date? string? or ??

Thanks and Regards.

annir

Answer 5

User-513735053 posted

podate = CDate(txtdate.Text.ToString("mm/dd/yyyy"))

 

Answer 6

User-952121411 posted

Here is the code you need:

        'Create a variable to hold a date representing an improperly formatted date (for this example)
        Dim MyDate1 As String = "1/2/2005"
        Dim MyStringDateFormatted As String = Format(Date.Parse(MyDate1), "MM/dd/yyyy")

 ... the output is as follows:

 

?MyStringDateFormatted
"01/02/2005"

...and for your example directly, try the following:

Dim MyStringDateFormatted As String = Format(Date.Parse(txtdate.Text.ToString), "MM/dd/yyyy")

Hope this helps!