It would help to know what database you're using, but make sure the date format in windows locale settings (I don't know where you'd find the equivalent in *nix) are set to ddmmyyyy, or, if the DB server has it's own settings for date format. Otherwise, try entering the date in ISO 8601...