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

Report message to a moderator

Re: complex calculation [message #403794 is a reply to message #403789] Mon, 18 May 2009 14:11 Go to previous message
Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic: Calculation error
Next Topic: Discoverer Report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 03:38:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.