Oracle VB date probs 2

[Bastien]

Hi All,

I have a date field that is input by the user which I need to convert to match a SQL expression later. The oracle DB expects the date as:

...= TO_DATE ('" & dteDate & "', 'DD-MON-YYYY') AND"


dteDate = txtDate.Text
dteDate = Format(dteDate, "dd-mmm-yyyy&quot

yet the date keeps not formatting at all...when I capture the sql statement, I get this:

...= TO_DATE ('2/22/02', 'DD-MON-YYYY')
when what I want is:
...= TO_DATE ('22-FEB-2002', 'DD-MON-YYYY')

any ideas?

TIA

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[ulwitch]

I am assuming that you have defined dteDate as Date. The format you are seeing (2/2/02) is the systems date format. The format function formats a string. You need to change this to a string.

Dim dtedate As String
dtedate = "2/2/02"
dtedate = Format(dtedate, "dd-mmm-yyyy&quot

 

[Bastien]

that was it...thanks Bastien

There are many ways to skin this cat,
but it still tastes like chicken