Hello,
I am using your dashboard date picker, but it doesn't appear to be giving expected results in my where clause in Oracle. Here's my where clause:
where
invoice_date between to_date(('G_PARAM<p34:Display>'),'dd:mon:yyyy') and
to_date(to_char('G_PARAM<p63:Display>'),'dd:mon:yyyy')
group by country_desc order by amount desc
Hello Semma,
The default date format for the date picker is dd-MMM-yyyy (e.g 01-Jan-2009). Assuming this format is not changed in the Date properties
Try the where clause as below (NOTE: there is no need to convert to to_char and then to date)
where invoice_date between to_date('G_PARAM<34:Display>','DD-MON-YYYY') and to_date('G_PARAM<63:Display>','DD-MON-YYYY')
group by country_desc order by amount desc
You must log in to post.