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 <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> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, May 25, 2018 11:37 AM To: rbase-l@googlegroups.com<mailto: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<mailto: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 <b...@downall.us<mailto:b...@downall.us>> To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> 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 <crobb...@iexgroup.com<mailto:crobb...@iexgroup.com>> 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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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.