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/yyyy. [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 <b...@downall.us> To: rbase-l <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. For more options, visit https://groups.google.com/d/optout.
