OraFAQ Forum: Reports & Discoverer » Hi-Adding a parameter As of Date

Home » Developer & Programmer » Reports & Discoverer » Hi-Adding a parameter As of Date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hi-Adding a parameter As of Date [message #254877]

Sun, 29 July 2007 22:40

selvalee
Messages: 1
Registered: July 2007
Location: India

Junior Member

Hi,
i need to put as on date in query.I have put like this
SELECT
XTA.TRUCK_NUMBER TRUCK_NO,
XV.DESCRIPTION TRUCK_DESCRIPTION,
XSP.STOCK_POINT STOCK_POINT,
XSP.DESCRIPTION STOCK_DESCRIPTION,
XV.CONTACT_NUMBER CONTACT_NUMBER,
XV.VENDOR_SITE_ID SUPPLIER,
PV.VENDOR_NAME VENDOR_NAME,
XV.TOTAL_CAPACITY CAPACITY,
XTA.FROM_DATE FROM_DATE,
XTA.TO_DATE TO_DATE,
XV.COMPANY ORG_ID
FROM
XXIS_VEHICLES XV,
XXIS_STOCK_POINT XSP,
XXIS_TRUCK_AVAILABILITY XTA,
PO_VENDORS PV,
PO_VENDOR_SITES_ALL PVS
WHERE
XTA.COMPANY=:P_ORG_ID
AND XV.COMPANY=XTA.COMPANY
AND XTA.STATUS='A'
AND XTA.COMPANY=XV.COMPANY
AND XSP.COMPANY=XTA.COMPANY
AND XSP.STOCK_POINT=XTA.FROM_STOCK_POINT
AND PV.VENDOR_ID=PVS.VENDOR_ID
AND PVS.SHIP_TO_LOCATION_ID=XV.VENDOR_SITE_ID
AND PVS.ORG_ID=XTA.COMPANY
AND TO_DATE(:P_AS_OF_DATE,'DD-MON-YYYY') BETWEEN XTA.FROM_DATE AND NVL(XTA.TO_DATE,TO_DATE(:P_AS_OF_DATE,'DD-MON-YYYY'))

but it is not happening,its says that->REP-0613: Value does not match mask 'DD-MON-YYYY'.Anyone can help me this issue to solve it out.

Regards,
Selva

Report message to a moderator