RE: [RBASE-L] - Blank date value

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

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 < rbase-l@googlegroups.com> wrote: > Bill: She's saying that NULL date values are displaying like that in a > form. > > Claudine:

RE: [RBASE-L] - Blank date value

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:

RE: [RBASE-L] - Blank date value

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

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

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

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`

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