on 12-08-2021 12:26 PM
Hello Experts,
I have a input paramter FISCAL_YEAR, in which I want to give default value an expression which is YEAR(CURRENT_DATE). But it does not work.
Any suggessions?
Thank You,
Best Regards,
Ajinkya Jadhav
Hi Ajinkya,
Go to the inpur parameter & on the value segment of the expression, click on the 3 dots, representing value help as shown below.
On the next screen, select language as 'SQL' under the language option changing from Column Engine (refer to screenshot below) & write the same expression, validate syntax & hit OK.
Activate the calculation view & it should work with default value as current year. Most likely your language is set as 'Column Engine' instead of 'SQL'.
Best Regards,
Abh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.