date format depending on OS

[Chinavo]

Hi

I have a DB where i put in some dates.

Im programming my application on a windos vista OS.
The format i pass the date is MMDDYYYY.

Now i run my application on a windos xp machine. When
i tried to put in the date an error appeard said wrong format.

When i change the format to DDMMYYYY then it works on the
windows xp machine.

Can anyone tell me if there is really a diffrence between the OS?
and how can i avoid that?? do i have to put in the format based
on the machine??

thx for the help.

chinavo

 

[JohnH]

Date string format is depending on culture settings and is only relevant when displaying dates as strings. In your DB you must use a Date column and save the Date values as Date values.