That's a great idea. You wouldn't think it would have to be that complicated.
Thank you, Buddy!
From: Buddy Walker <[email protected]>
To: [email protected]
Sent: Tuesday, February 14, 2017 5:11 PM
Subject: RE: [RBASE-L] - problem with null values
#yiv6258045120 #yiv6258045120 -- _filtered #yiv6258045120
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv6258045120
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6258045120
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv6258045120
#yiv6258045120 p.yiv6258045120MsoNormal, #yiv6258045120
li.yiv6258045120MsoNormal, #yiv6258045120 div.yiv6258045120MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv6258045120 a:link,
#yiv6258045120 span.yiv6258045120MsoHyperlink
{color:blue;text-decoration:underline;}#yiv6258045120 a:visited, #yiv6258045120
span.yiv6258045120MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv6258045120
p.yiv6258045120msonormal0, #yiv6258045120 li.yiv6258045120msonormal0,
#yiv6258045120 div.yiv6258045120msonormal0
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6258045120
span.yiv6258045120EmailStyle19 {color:windowtext;}#yiv6258045120
.yiv6258045120MsoChpDefault {font-size:10.0pt;} _filtered #yiv6258045120
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv6258045120 div.yiv6258045120WordSection1
{}#yiv6258045120 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
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.
--
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.
