This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,924 Users
  • 2,269,775 Discussions


Date comparison using Calender Prompt


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


This discussion has been closed.