ATTN: VB PRO'S (Aaron Young, MartinLiss, Yonatan, and others) formatting a text box

[Gimpster]

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).]

[Aaron Young]

Just use the Format Function, ie.

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]

[Gimpster]

Thank you so much! It works perfectly!

------------------
Ryan