Date comparison using Calender Prompt

vjbez1

Hi,

My Requirement is to create a calender date prompt for start and end dates and filter data based on those dates.

I have three conditions to satisfy.
1) Date in columnA >= Start date
2)Date in columnA < End Date
3) Date in columnB < End Date

I am facing issues with this comparison. The format of the calender in the prompt is as 'YYYY-MM-DD HH:MM:SS' and that in the column is in 'MM/DD/YYYY HH:MM:SS'

I tried converting both of these to a Date format using CAST and then use them in the filter, but it does not work.

Is there a way to work with this and convert both of them into a single format and then compare.

I have other reports in which I have to use a "Equals to" operator and I was able t get it done by converting both of them in to Character. But the Greater Than and Less than are the problem.

Any Help in this will be greatly appreciated.

Please reply if you need any more information.

I am using 10.1.3

SriniVEERAVALLI

Check this may help you
http://108obiee.blogspot.com/2009/03/how-to-change-date-format-mask-in-date.html

Pls mark if helps

vjbez1

Hi veeravalli,

I do not want to make any changes to the default configuration as I will not be able to get those changes in the QA or production environment. Do you see any other ways of using the CAST function to achieve this requirement?

Thanks for your reply...

808195

Can you please post the error what you are getting.

MuRam

Hi,

You can change the Data format tab of the column to the same as prompt type and try passing the values.

Hope this helped/ answered.

Regards
MuRam