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 wor
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 brute-
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
us
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?
It's
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 tha
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\&Invoice_1031.PDF’
PRINT validate +OP
6 matches
Mail list logo