date:20180525

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins

No problem Bill.  I still refer to your and David’s SQL book almost monthly.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bill Downall
Sent: Friday, May 25, 2018 1:31 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Blank date value

So sorry. I jumped in to the middle of the conversation, and missed the main 
details.

(sent from Moto Z)

On Fri, May 25, 2018, 8:34 AM karentellef via RBASE-L 
> wrote:
Bill:  She's saying that NULL date values are displaying like that in a form.

Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?

Karen



-Original Message-
From: Bill Downall >
To: rbase-l >
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value
Claudine,

If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them.

Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.

SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'

UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'

Bill

On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins 
> wrote:
Hello all,

I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.

I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.

Any ideas on how to fix this?

TIA,

Claudine
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Blank date value

2018-05-25 Thread Bill Downall

So sorry. I jumped in to the middle of the conversation, and missed the
main details.


(sent from Moto Z)

On Fri, May 25, 2018, 8:34 AM karentellef via RBASE-L <
rbase-l@googlegroups.com> wrote:

> Bill:  She's saying that NULL date values are displaying like that in a
> form.
>
> Claudine:  does the database see them as null?  If you did a select where
> datecol is null, do they show up?
>
> Karen
>
>
>
> -Original Message-
> From: Bill Downall 
> To: rbase-l 
> Sent: Fri, May 25, 2018 7:19 am
> Subject: Re: [RBASE-L] - Blank date value
>
> Claudine,
>
> If you can write a WHERE clause that finds all the bad dates, you should
> be able to write an UPDATE that fixes them.
>
> Are all the wrong dates off by exactly a century? If not, you will have to
> make your WHERE clause more complicated, and do this more than once.
>
> SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'
>
> UPDATE tablename SET datecolumn = +
>  (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
> WHERE datecolumn <= '01/01/1900'
>
> Bill
>
> On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins 
> wrote:
>
> Hello all,
>
> I’m on latest release.  Some null values in a date field on a form are
> coming up 12/30/99, fully extended to 12/30/1*8*99!  There are no values
> in that field in the table and the field correctly takes whatever date is
> inserted and saves it to the table.
>
> I switched from 2-digit year to 4-digit year a few months ago and wonder
> if that’s when this started.  I reloaded the database, ran it through
> R:Scope and all is sound.
>
> Any ideas on how to fix this?
>
> TIA,
>
> Claudine
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins

Thanks Paul.  I believe my misapplying date formatting (formatting in two 
places for the same field) may be responsible for this…

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Paul C. Buckley
Sent: Friday, May 25, 2018 12:55 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

Claudine,

Just as a test you might try this, not knowing the complexity of this form, you 
might create a new form based on the same table/view and do a control-A – copy 
all from the original and paste it into the new form. It won’t bring all the 
form settings and any variables you may have defined but all the fields and 
anything on the screen will be copied. Try the new form and see what happens.

Just a thought. Good luck,
Paul Buckley

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: May 25, 2018 1:05 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

Furthermore, I recreated the DBEdit field on the form with no change.  However, 
I created a test form based on the same table and that date value is indeed 
NULL so that clearly points to my form.  I’ll continue playing with it and 
report my findings.  Probably something I’m unaware of doing wrong…

Claudine

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, May 25, 2018 11:37 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

Yes Karen. This is a phantom value.  All the NULL rows show this in the form 
but the table shows NULL values.  If I click on it while in the form, it 
vanishes…

My settings:
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES  '
PLUS+
SINGLE  _
MANY%
IDQUOTES`
[cid:image001.png@01D3F429.87653630]

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, May 25, 2018 7:35 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Blank date value

Bill:  She's saying that NULL date values are displaying like that in a form.

Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?

Karen

-Original Message-
From: Bill Downall >
To: rbase-l >
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value
Claudine,

If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them.

Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.

SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'

UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'

Bill

On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins 
> wrote:
Hello all,

I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.

I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.

Any ideas on how to fix this?

TIA,

Claudine
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins

I removed the date display format for that field in the tables tab and the 
display format for non-text values on the DBEdit field and that removes the 
phantom entry.  Yeah!

Perhaps I don’t clearly understand what the Tables tab Display Format means. I 
have two other date fields formatted to mm/dd/yy which correctly show up on the 
form as formatted in one place and the same fields in a DBLookup Listview based 
on the same table which show as mm/dd/.

[cid:image003.jpg@01D3F429.11F2FD10]

[cid:image007.jpg@01D3F429.11F2FD10]

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, May 25, 2018 12:05 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

Furthermore, I recreated the DBEdit field on the form with no change.  However, 
I created a test form based on the same table and that date value is indeed 
NULL so that clearly points to my form.  I’ll continue playing with it and 
report my findings.  Probably something I’m unaware of doing wrong…

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, May 25, 2018 11:37 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

Yes Karen. This is a phantom value.  All the NULL rows show this in the form 
but the table shows NULL values.  If I click on it while in the form, it 
vanishes…

My settings:
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES  '
PLUS+
SINGLE  _
MANY%
IDQUOTES`
[cid:image001.png@01D3F426.E6485130]

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, May 25, 2018 7:35 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Blank date value

Bill:  She's saying that NULL date values are displaying like that in a form.

Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?

Karen



-Original Message-
From: Bill Downall 
To: rbase-l 
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value
Claudine,

If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them.

Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.

SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'

UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'

Bill

On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins 
> wrote:
Hello all,

I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.

I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.

Any ideas on how to fix this?

TIA,

Claudine
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Paul C. Buckley

Claudine,

 

Just as a test you might try this, not knowing the complexity of this form, you 
might create a new form based on the same table/view and do a control-A – copy 
all from the original and paste it into the new form. It won’t bring all the 
form settings and any variables you may have defined but all the fields and 
anything on the screen will be copied. Try the new form and see what happens.

 

Just a thought. Good luck,

Paul Buckley

 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: May 25, 2018 1:05 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

 

Furthermore, I recreated the DBEdit field on the form with no change.  However, 
I created a test form based on the same table and that date value is indeed 
NULL so that clearly points to my form.  I’ll continue playing with it and 
report my findings.  Probably something I’m unaware of doing wrong…

 

Claudine

 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, May 25, 2018 11:37 AM
To: rbase-l@googlegroups.com  
Subject: RE: [RBASE-L] - Blank date value

 

Yes Karen. This is a phantom value.  All the NULL rows show this in the form 
but the table shows NULL values.  If I click on it while in the form, it 
vanishes…

 

My settings:

BLANK

DELIMIT ,

LINEEND ^

SEMI;

QUOTES  '

PLUS+

SINGLE  _

MANY%

IDQUOTES`



 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Friday, May 25, 2018 7:35 AM
To: rbase-l@googlegroups.com  
Subject: Re: [RBASE-L] - Blank date value

 

Bill:  She's saying that NULL date values are displaying like that in a form.   

 

Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?

 

Karen

 

 

 

-Original Message-
From: Bill Downall  >
To: rbase-l  >
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value

Claudine, 

 

If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them. 

 

Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.

 

SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'

 

UPDATE tablename SET datecolumn = +

 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +

WHERE datecolumn <= '01/01/1900'

 

Bill

 

On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins  > wrote:

Hello all,

 

I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.

 

I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.

 

Any ideas on how to fix this?

 

TIA,

 

Claudine

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com 
 .
For more options, visit

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins

Furthermore, I recreated the DBEdit field on the form with no change.  However, 
I created a test form based on the same table and that date value is indeed 
NULL so that clearly points to my form.  I’ll continue playing with it and 
report my findings.  Probably something I’m unaware of doing wrong…

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, May 25, 2018 11:37 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

Yes Karen. This is a phantom value.  All the NULL rows show this in the form 
but the table shows NULL values.  If I click on it while in the form, it 
vanishes…

My settings:
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES  '
PLUS+
SINGLE  _
MANY%
IDQUOTES`
[cid:image001.png@01D3F420.8F8B05A0]

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, May 25, 2018 7:35 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Blank date value

Bill:  She's saying that NULL date values are displaying like that in a form.

Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?

Karen



-Original Message-
From: Bill Downall 
To: rbase-l 
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value
Claudine,

If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them.

Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.

SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'

UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'

Bill

On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins 
> wrote:
Hello all,

I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.

I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.

Any ideas on how to fix this?

TIA,

Claudine
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins

Yes Karen. This is a phantom value.  All the NULL rows show this in the form 
but the table shows NULL values.  If I click on it while in the form, it 
vanishes…

My settings:
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES  '
PLUS+
SINGLE  _
MANY%
IDQUOTES`
[cid:image001.png@01D3F41C.A7091BD0]

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, May 25, 2018 7:35 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Blank date value

Bill:  She's saying that NULL date values are displaying like that in a form.

Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?

Karen



-Original Message-
From: Bill Downall 
To: rbase-l 
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value
Claudine,

If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them.

Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.

SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'

UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'

Bill

On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins 
> wrote:
Hello all,

I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.

I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.

Any ideas on how to fix this?

TIA,

Claudine
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Blank date value

2018-05-25 Thread karentellef via RBASE-L


Bill:  She's saying that NULL date values are displaying like that in a form.   



Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?


Karen

 

 

 

-Original Message-
From: Bill Downall 
To: rbase-l 
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value



Claudine,


If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them. 


Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.


SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'


UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'


Bill


On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins  wrote:


Hello all,
 
I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.
 
I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.
 
Any ideas on how to fix this?
 
TIA,
 
Claudine


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Blank date value

Re: [RBASE-L] - Blank date value

RE: [RBASE-L] - Blank date value

RE: [RBASE-L] - Blank date value

RE: [RBASE-L] - Blank date value

RE: [RBASE-L] - Blank date value

RE: [RBASE-L] - Blank date value

Re: [RBASE-L] - Blank date value

8 matches

Site Navigation

Mail list logo

Footer information