Thanks for everyone's help in solving my dilemma with calculating a person's age.
Building on everyone's suggestions, I finally solved my problem with the following code:
TO_CHAR(FLOOR(MONTHS_BETWEEN(SYSDATE,Birthdate)/12))
I now get the correct age without a decimal point.
As a newbie to...
hilfy,
Thx for the suggestion. The whole number I'm getting now is correct; however I'm still getting a decimal.
For example, birthdate 21-DEC-1951 returns age 52.99, based on SYSDATE of 17-DEC-2004.
Much better than I had, at least the 52 is correct.
According to my Discoverer Handbook...
Sem,
Thanks for the suggestion. Being new to Discoverer, I was unaware of a Months_Between function. I'll give it a try. Also, the leap years dilemma is something I'm seeking help to resolve. I suspect some of the Discoverer gurus on this forum have already figured a way to accurately...
Me again,,,the Discoverer newbie.
I'm trying to determine a person's age using the following code:
( TRUNC(SYSDATE) - TRUNC(Birthdate) )/365
Two problems with this formula:
1. Birthdate of 25-May-1951, the age displays as
53.60. I need to display only 53.
2...
Despite all my searches and using my Discoverer Handbook, I can't get the following concatenation to work as desired:
CONCAT(Last Name,First Name)
The problem is how can I get a space between the last name and the first name using concatenation? I've tried numerous things, no luck.
TIA...
rac2,
thanks for the insight & suggestions. I'll use your ideas and see if they work. Stay tuned, this could get interesting ;>)
Seriously, I really appreciate your taking the time to respond. Being new at this SQL stuff has proven to be quite a challenge. I can use all the help I can get!
I tried to "search" on this forum, however the "search" function is currently not available.
I'm very new to SQL, so please bear with me. The code below gives this result:
LWIA Participants
00 1
However, if I remove the Having statement, I get LWIA
00 through 13, which...
dhookom,
Thx for the suggestions. But, still no luck.
I'm really hoping someone can help me solve this.
Otherwise, I'll have to start over and change tables,logic, etc to get the report fixed.
Again, thx for your help.
Thanks for your help, Randy.
I apologize for bothering you and others for the Forms Forum with a Report problem.
I'll take your advice and post on the Reports Forum.
Report problem, see script & description of problem below, please. The problem seems to be with the txtTitle field.
Is there any way to have a visible=false not allow for the space to print the field.
The problem occurs in the GroupHeader0 section. Even though I put txtTitle.visible=False, it...
Randy,
First let me apologize, still trying to get the names down...obviously not doing a good job at it.
This is actually a report, not a form (sorry).
The problem occurs in the GroupHeader0 section. Even though I put txtTitle.visible=False, it still makes room for the txtTitle on the...
I'm a newbie, so be gentle ;>)
I have a form with a Group Header on which I print
a field called txtTitle, txtTitle.visible-true. This is determined based on whether or not the field txtbold is true or false. If txtbold is true, txtTitle is visible.
On the same form I have a detail area...
I posted the following to the Tek-Tips forum for Novell Groupwise last week, and haven't gotten a response. Since it involves Access, perhaps someone on this forum can assist me.
I need to save certain emails and copy/paste them into an Access database. I've done the "Save As", but the only...
I need to save certain emails and copy/paste them into an Access database. I've done the "Save As", only option is to save the email as a .doc, which doesn't include every recipient, including CC and BC.
Is there a way to save email and include ALL recipients and attachments so I can paste...
Thanks to foolio12, my page footer dilemma got solved yesterday, now I have another situation.
Not to self: Seems that whenever I include another subreport something else happens. Oh well, live and learn :>)
One of the 9 subreports that I've included in my Main report is using a Page Header...
Hi BNPMike,
Since I'm new to this site, could you explain what a
"Star Button" is?
BTW: thanks for giving foolio12 a Star for me. He certainly deserves it!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.