HELP ASAP !! How do you convert DD/MM/YYYY to MM/DD/YYYY in VB6
Posted on 2005-05-02
I am taking dates input as DD/MM/YYYY and converting them internally. At first I thought the format function would work.
I used the format("15/01/2005","MM/DD/YYYY") and that works, converting it to "01/15/2005"
Then I tried another date... format("01/05/2005","MM/DD/YYYY") which should have converted to 05/01/2005 but the output was "01/05/2005"
Is there a way to make it work for all dates and not just those with a day greater than 12?
I am giving 500 points for the answer to this.