-
What I need is some way of rearranging the format of a date in a text box. The problem is that the date is not always going to be in the same format, meaning that it would be in the one of the following formats
- m/d/yy
- m/dd/yy
- mm/d/yy
- mm/dd/yy
and I need to change it into this format:
yyyy-mm-dd
maybe there's another way to do this besides what I'm thinking, but here's what I think I'm going to have to do. I'm thinking of how you do this using PERL, and I was wondering if there is some way to do something similar in VB. I need to find some way of searching the date string for the '/' that are always in the date string. And then from there I can rearrange the order and separate them by the '-'.
------------------
Ryan
[This message has been edited by Gimpster (edited 01-13-2000).]
-
Just use the Format Function, ie.
Code:
Private Sub Command1_Click()
Text1 = Format(Text1, "yyyy-mm-dd")
End Sub
It will take the Date in any of the Formats you described, and more, and put in the Format yyyy-mm-dd.
------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]
-
Thank you so much! It works perfectly!
------------------
Ryan
