Skip to Content
0
Former Member
Jul 02, 2009 at 10:06 AM

Date parameter

37 Views

Hi,

I'm using CR 11 in an Oracle DB. I don't know why there's an error like

Ora-00936: missing expression

once I've put these 2 lines in the script (the 2 date parameters are with the string data type)

and vp.date_field >= to_char(to_date({?date_from},'dd-mm-rr'),'yyyymmdd')

and vp.date_field <= to_char(to_date({?date_to},'dd-mm-rr'),'yyyymmdd')