Yes, I realized I wrote the wrong name. I am looking for the most recent date,
not the oldest. (I'm writing emails too fast.)
I'm trying to apply this to the entire table at once. I don't know any other
way of finding the most extreme date of those three in each record.
Patti
From: Stephen Markson <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Wednesday, February 15, 2017 11:27 AM
Subject: RE: [RBASE-L] - problem with null values
#yiv9668207390 #yiv9668207390 -- _filtered #yiv9668207390
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv9668207390
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv9668207390
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv9668207390
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv9668207390
#yiv9668207390 p.yiv9668207390MsoNormal, #yiv9668207390
li.yiv9668207390MsoNormal, #yiv9668207390 div.yiv9668207390MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9668207390 a:link,
#yiv9668207390 span.yiv9668207390MsoHyperlink
{color:blue;text-decoration:underline;}#yiv9668207390 a:visited, #yiv9668207390
span.yiv9668207390MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv9668207390 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9668207390
span.yiv9668207390EmailStyle18
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv9668207390
.yiv9668207390MsoChpDefault {font-size:10.0pt;} _filtered #yiv9668207390
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv9668207390
div.yiv9668207390WordSection1 {}#yiv9668207390 Here are a couple of
suggestions. First thing is that LMAX(list of dates) will give you the
greatest date, not the oldest. Regardless of what you are looking for, you
need to determine what the most extreme date in your data is. Set a variable
for that value and then substitute it in Buddy’s formula. Except for
numbers with ZERO ON, NULL values can’t be used in any calculations or logical
test because R:Base doesn’t know what the value is. E.g. comparing ‘text value’
to NULL always results in FALSE. Is ‘fred’ less than, greater than or equal to
NULL? Regards, Stephen Markson The Pharmacy Examining Board of Canada
416.979.2431 x251 From: 'Patti Jakusz' via RBASE-L
[mailto:[email protected]]
Sent: February-14-17 6:37 PM
To: [email protected]
Subject: Re: [RBASE-L] - problem with null values Thank you, Jan. From:
jan johansen <[email protected]>
To: [email protected]
Sent: Tuesday, February 14, 2017 5:16 PM
Subject: RE: [RBASE-L] - problem with null values Patti, Buddy beat me to
it but sometimes when we are using an older database, we actually saved a space
for a null so you may need to check to see if you actually have nulls. Jan
-----Original Message-----
From: "Buddy Walker" <[email protected]>
To: <[email protected]>
Date: Tue, 14 Feb 2017 17:11:14 -0500
Subject: RE: [RBASE-L] - problem with null values
Patti You might want to try something like this depending on how you want
to hand null dates. It my example I’m saying if date is null then make it
12/31/2999 or whatever date you want. …. OldestDate =
(LMAX((IFNULL(DATE1,12/31/2999,DATE1)),(IFNULL(DATE2,12/31/2999,DATE2)),(IFNULL(DATE3,12/31/2999,DATE3))))
I didn’t test this so make sure to test on a copy of database Buddy
From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]]
Sent: Tuesday, February 14, 2017 3:38 PM
To: [email protected]; RBASE-L <[email protected]>; RBASE-L
<[email protected]>
Subject: [RBASE-L] - problem with null values Hello, I'm using Rbase 10.
I'm trying to update one date column in my table to be the oldest of 3 other
date columns. My command is: update Table1 set OldestDate = (LMAX(date1,
date2, date3)) But it only works if all three dates have values. I have zero
set on. I tried setting on Eqnull. But I only get a blank if one of the dates
is null. Is there another setting to turn on? Thanks, Patti --
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
[email protected].
For more options, visit https://groups.google.com/d/optout. --
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
[email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
[email protected].
For more options, visit https://groups.google.com/d/optout. --
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
[email protected].
For more options, visit https://groups.google.com/d/optout. --
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
