OraFAQ Forum: Reports & Discoverer » returning value date from formula

Home » Developer & Programmer » Reports & Discoverer » returning value date from formula

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

returning value date from formula [message #635342]

Fri, 27 March 2015 03:47

mikrimouse1
Messages: 4
Registered: March 2015

Junior Member

function lastdayinmonthFormula return Number is
begin
last_day(to_date(to_char('01'||lpad(:month,2,'0')||:year),'ddmmyyyy'))
end;

Now i dont know how to return this last day, I enter month and year in param form and i after i run report i get error , how do I return value from last_day ?
Thanks

Report message to a moderator

Re: returning value date from formula [message #635343 is a reply to message #635342]

Fri, 27 March 2015 03:51

Littlefoot
Messages: 21781
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You need to return it, literally.

begin
  return last_day ...;
end;

Report message to a moderator

Re: returning value date from formula [message #635344 is a reply to message #635343]

Fri, 27 March 2015 03:53

mikrimouse1
Messages: 4
Registered: March 2015

Junior Member

it doesnt work like that i tried
return last_day(to_date(to_char('01'||lpad(:mjesec,2,'0')||:par),'ddmmyyyy'));
and i get error expression is of wrong type

[Updated on: Fri, 27 March 2015 03:57]

Report message to a moderator

Re: returning value date from formula [message #635345 is a reply to message #635343]

Fri, 27 March 2015 03:56

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Also you'll need to fix the return type, last_day gives a date not a number.

Report message to a moderator

Re: returning value date from formula [message #635346 is a reply to message #635344]

Fri, 27 March 2015 03:57

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

mikrimouse1 wrote on Fri, 27 March 2015 08:53

it doesnt work like that i tried
return last_day(to_date(to_char('01'||lpad(:mjesec,2,'0')||:par),'ddmmyyyy'))
and i get error encountered the symbol END when exepting ..

Missing semi-colon

Report message to a moderator

Re: returning value date from formula [message #635347 is a reply to message #635345]

Fri, 27 March 2015 04:03

mikrimouse1
Messages: 4
Registered: March 2015

Junior Member

Stupid me, thats correct , function return date not number

Report message to a moderator

Previous Topic:	show all values instead of null or as field type.
Next Topic:	2D barcode in report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 00:50:06 CDT 2023