Re: Re[2]: [RBASE-L] - Calculating Age in Years, Months | PRIVATE

If you are doing this for every row in your database, you might create a view rather than calculate row by row. You could add the Y & M as part of your report fields. You could limit your view to "WHERE DeathDateTime IS NOT NULL" , or "WHERE DeathDateTime EXISTS." Might something like this

Re[2]: [RBASE-L] - Calculating Age in Years, Months | PRIVATE

I apologize for using the word "ugly" . Rather, your code is elegant in that it really could not be reduced further without one helluva lot of work, as the 2016 approach suggests. I should have remembered my 9th grade geometry final, where, confronted with a jungular tangle of lines, I

Re: [RBASE-L] - Calculating Age in Years, Months

Hi, Bruce - Thanks for your time and response. I spent an inordinate amount of time and effort to create a working formula, and thought there must be an easier way. I had in mind a function similar to DATEDIF in Excel. Glad to have the opinion of someone more versed in R:Base than I am. I will

Re: [RBASE-L] - email novice problems

Thanks, Karen: I will try this later on today. On Saturday, November 11, 2023 at 08:50:59 AM EST, 'Karen Tellef' via RBASE-L wrote: Here's a copy of code that runs fine every day (all data is sent in by variables).  Perhaps compare to your code and see what the differences are? 

Re: [RBASE-L] - email novice problems

Here's a copy of code that runs fine every day (all data is sent in by variables).  Perhaps compare to your code and see what the differences are?  It's been a long time since I've messed with this code; we embedded the host/port/authentication within the print itself for some reason rather

Re: [RBASE-L] - email novice problems

Hi, Jim: Thanks for the suggestion.  I tried the attachment option (code listed below), Still - no go.I know this looks easy enough, but it isn't working.   Am i missing something ? SET MESSAGES ONSET ERROR MESSAGES ON Set var vfilename TEXT = ‘c:\emailtest\_1031.PDF’ PRINT validate  +OPTION