Gimpster
Jan 13th, 2000, 08:00 AM
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).]
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).]