Prompt for Date

building reports desktopintelligence
1

I just experienced an interesting problem and would like to share it with the group to potentially help others and to see if anyone has any insight into it.

V4.1.5, Oracle8, Full Client

A user sent me a report with a query using ‘BETWEEN’ and two user prompts to select a date range. When executing, I got a “Not a Valid Month” error and it wouldn’t run. After pulling my hair out for a while, I finally deleted his prompts and put my own it…then it worked fine ! ! I could not see anything wrong with the prompts he had used, and also don’t think the prompt text should have any effect on the SQL generated for Oracle ??

Dan D Mahon
Enterprise Data Manager
ADVO, Inc.
860-285-6319
DDMAHON@ADVO.COM

Listserv Archives (BOB member since 2002-06-25)

2

There is an Oracle.SBO file in the \Business Objects\Data Access\Oracle folder in which the following line is contained :

InputDateFormat=‘DD-MM-YYYY HH:MM:SS’
InitDateFormat=‘DD-MM-YYYY HH24:MI:SS’

One possibility is that their SBO file may be listing it as MM-DD-YYYY instead of DD-MM-YYYY which is why it may have worked for you…just something to check out.

ddmahon@ADVO.COM 02/17/00 03:21PM >>>
V4.1.5, Oracle8, Full Client
When executing, I got a “Not a Valid Month” error and it wouldn’t run. After pulling my hair out for a while, I finally deleted his prompts and put my own it…then it worked fine ! !

Listserv Archives (BOB member since 2002-06-25)