Home » Developer & Programmer » Reports & Discoverer » complex calculation (disc 10.1.2)
complex calculation [message #403789] Mon, 18 May 2009 13:04 Go to next message
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi all
I have two fields report month and report year and i concatenated the two fields to make it as Report Date :mm/yyyy
now how can i change it to mm/dd/yyyy where the dd is always defaulted to be the last day of the month.

Re: complex calculation [message #403794 is a reply to message #403789] Mon, 18 May 2009 14:11 Go to previous message
Messages: 21131
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So concatenate the last day of the month with month and year. LAST_DAY (how convenient!) will return wanted value.
Previous Topic: Calculation error
Next Topic: Discoverer Report
Goto Forum:

Current Time: Thu Jul 27 02:00:10 CDT 2017

Total time taken to generate the page: 0.26229 seconds