<div>
Is the prompt working?<br />
<br />
Try entering the date in the system format based on the regional settings.<br />
<br />
mlmcc
</div>


Is the prompt working?

Try entering the date in the system format based on the regional settings.

mlmcc

<div>
What is 'system format based' date?
</div>


<div>
The regional settings under control panel<br />
<br />
mlmcc
</div>


The regional settings under control panel

mlmcc

<div>
This question has been classified as abandoned and is being closed as part of the Cleanup Program. &nbsp;See my comment at the end of the question for more details.
</div>


This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.

<div>
<div class="content wysiwyg-content">
<br />
<br />
I have a task of creating a report where I have to get the list of employees who were born in a particular month based on the Month End Date Entered. I used both below prompt filters,<br />
<br />
to_char(( HRMART.EMP_DIM.BIRTH_DT ),'MM') =to_char(to_date(@Prompt('<wbr />Enter Month End Date:','D',,,),'MM/dd/yyyy<wbr />'),'MM')<br />
<br />
(or)<br />
<br />
to_char(( HRMART.EMP_DIM.BIRTH_DT ),'MM') =to_char(to_date(@Prompt('<wbr />Enter Month End Date:','A',,,),'MM/dd/yyyy<wbr />'),'MM')<br />
<br />
<br />
but I get this error &quot;Database error: ORA-01843: not a valid month. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)&quot;<br />
<br />
Can someone suggest on how to do this?<br />
<br />
Thanks in Advance
</div>
</div>




I have a task of creating a report where I have to get the list of employees who were born in a particular month based on the Month End Date Entered. I used both below prompt filters,

to_char(( HRMART.EMP_DIM.BIRTH_DT ),'MM') =to_char(to_date(@Prompt('Enter Month End Date:','D',,,),'MM/dd/yyyy'),'MM')

(or)

to_char(( HRMART.EMP_DIM.BIRTH_DT ),'MM') =to_char(to_date(@Prompt('Enter Month End Date:','A',,,),'MM/dd/yyyy'),'MM')


but I get this error "Database error: ORA-01843: not a valid month. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)"

Can someone suggest on how to do this?

Thanks in Advance

Business Objects Prompt Filter

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.