Home » Developer & Programmer » Reports & Discoverer » Datesas paramaeters (disc 10.1.2)
Datesas paramaeters [message #411750] Mon, 06 July 2009 10:00
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All,
I have a page item ( a calculated field=TO_CHAR(DW_ITS_TGT.GEMS_RECEIVED_DATE,'Month')), how do i get the months from the page item in the order of months like JAN,FEB,MARCH.....DEC.
Secondly i have a date field, on which i'm trying to set up a page item, shich is in the format "dd-mon-yy hh:mm:ss" (i tried to_date but i'm still getting the hh:mm:ss), And how do i add the page items, where i can filter a day in the week like MON,TUE,WED OR GROUP LIKE "MON-THUR" AND "FRI TO SUN" and also another parameter where i can filter by the time "for example: 6.00am to 3.00pm" all these parameters are based on the same date field.

Thanks All
Previous Topic: How to predefine to save the output file
Next Topic: using operators
Goto Forum:
  


Current Time: Fri Mar 29 03:51:11 CDT 2024