Macro

[EArumugam]

I am using the following code
#prompt('fiscal','integer','year(getdate())')# for making the current year as default selection in value prompt

but i am getting the below error..

RQP-DEF-0177
      An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00904: "YEAR": invalid identifier

it urgent , please clarify

[david.stachon]

...looks like you are using Microsoft syntax to talk to an Oracle database..

try this instead:

your: year(getdate())

...will need to be something more like:

to_integer(to_char(sysdate(),'yyyy'))

(sorry, i don't have an oracle db to test against, but hopefully you get the idea)