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