Tags:

APEX IR - Date Filter usage like String columns

Von Tobias Arnhold 5.25.2012
If you want to filter date values like this:


Then extend the code to your date columns (inside the region source) like this:
  My date column name is: IMPORT_DATE
  select
  ...
  decode(IMPORT_DATE,null,null,'<!-- ' || to_char ( IMPORT_DATE, 'yyyymmdd' ) || ' -->' || IMPORT_DATE) as IMPORT_DATE
  from
  ...

For more information take a look into this forum thread:
https://forums.oracle.com/forums/thread.jspa?threadID=2346579&start=15&tstart=0

Post Tags:

2 Comments " APEX IR - Date Filter usage like String columns "

hoh 13 July, 2012 13:35
This comment has been removed by the author.
hoh 13 July, 2012 13:41

Replace '<!--' with '<', and '-->' with '>', and that works as you intended.

Make sure the display-as for the column is 'Remove HTML and escape special characters'.

Regards,
Markus H.

Have a nice time in your vacation. :-)