| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
