Hi, I'm using VB 2005 and was wondering how come when I use an input box to do a date search in a access database I alway have to format the input box results as MM/dd/yyyy format. I'm in the UK and my windows, office and VB setting are set as standard for the UK which is dd/MM/yyyy.

If somebody in the us was to use my package would they have a problem typing in a search date. In the UK we would type 01/12/2006 (1st Dec 2006) where as in the us they would type (12/01/2006) (Dec 1st 2005). I am concerned because My software is now ready to be released but this might be a small problem.

Can anybody help me.

Thanks
Pete*

__________________
Simplicity is the key

I don't know why it does that but I did find that if I change the date from dd/mm/yyyy to dd/mmm/yyyy e.g. 05/10/2005 changed to 05/Oct/2005 it works correctly.

That might be a smaller change to your application.

Hi peterasimpson,
I think it's better if you parameterize your application date format. Save the date format in App.config and retrieve it from there when formatting dates in your application. Don't hard code the date format in your application. Otherwise if another customer requests the application with a different date format. You'll have to maintain a different project for that customer.


nalaka hewage