Applies to:Product Release: V7 (Professional)
Version: 7.7.2 
Database: Oracle 18.104.22.168
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Sun Solaris 8
This document was previously published as Siebel SR 38-1929532745.
Changing the short date format from 'dd-MMM-yyyy' to 'dd/MMM/yyyy' we can no longer query correctly on date fields. I find I have to enter the date in the format of 'dd/MMM/yyyy' to get it work.
The Date Separator is dash, and I can see dates in the format defined by the Short Date Format, but separated by dash , as expected.
On Administration - Data > Locale, select the locale (ENU in this case).
Set the short date format 'dd/MMM/yyyy' and using "-" (dash) as Date Separator.
Date are displayed fine with dash, for example: 3-2-2005 02:59:36 PM
However , users cannot query on date fields using dash. If querying by 3-2-2005 for example, It gives the error :
"The query could not run because the criteria for field "Date Opened" contained an invalid arithmetic expression. Please, ensurethat the search criteria is correctly formatted.
This error is often caused by a missing operator (e.g. = or &|t) or missing quotes. If you aren't sure what may have caused this please contact your system administrator.(SBL-DAT-00345)"
Change Request 12-VYYQD3 has been logged to address this behavior
1) Querying date using slash works fine
2) Set the short date format 'dd-MMM-yyyy' (with dash) and use "-" (dash) as Date Separator as well.
Query can be executed fine.
3) ask for a fix for this behavior.