is there a vb function that will convert string month like "Jan" into integer value of 1?
TIA
Printable View
is there a vb function that will convert string month like "Jan" into integer value of 1?
TIA
I don't believe a function exists just for that, so you'd need to write your own.
You could use the Month function (Microsoft.VisualBasic namespace) by passing your monthname along with " 1, 2005" appended to it... something like
MessageBox.Show(Month(Date.Parse(strMonthName & " 1, 2005")))
Not sure, but you'd have to try this out, as I don't have the IDE open.
ok thanks, well i guess i have to use my own function for this for now.