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
aarti81
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.


Thanks
Re: complex calculation [message #403794 is a reply to message #403789] Mon, 18 May 2009 14:11 Go to previous message
Littlefoot
Messages: 21821
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 Nov 07 17:22:12 CST 2024