Thanks Paul. I believe my misapplying date formatting (formatting in two places for the same field) may be responsible for this…
Claudine From: [email protected] [mailto:[email protected]] On Behalf Of Paul C. Buckley Sent: Friday, May 25, 2018 12:55 PM To: [email protected] 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: [email protected] <[email protected]> On Behalf Of Claudine Robbins Sent: May 25, 2018 1:05 PM To: [email protected] 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: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Friday, May 25, 2018 11:37 AM To: [email protected]<mailto:[email protected]> 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:[email protected]] From: karentellef via RBASE-L [mailto:[email protected]] Sent: Friday, May 25, 2018 7:35 AM To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
