Printable View
in my excel spreadsheet i used format of dd/mmm
and internally excel has stored it as mm/dd/yyyy.
i then used this column to populate the combobox in vb. the combobox gets populated with the internal format of mm/dd/yyyy.
but when i read the whole column back to display it in a listbox, i get error.
i guess the error is due to the difference in formats. can anyone help suggesting anything please?????
Hi,
Correct me if I'm wrong here, but most of Mr Bill's software follow the Windows short date format. So check it out first, and I do believe that VB is running on the short date format.
I've used a reporting application which was built with VB, and we had another application interfacing with this, which had a date format of "yyyy/mm/dd" while the program had the format "dd/mm/yyyy". When the application was executed to print out the report, we found that the date field was missing, so, we changed the short date format to follow "yyyy/mm/dd" and the problem was solved!!
Check it out... hope this helps
____________________________________
The VB Bugs in my Life...