Re: Standards question on edited fields

From: Judson McClendon (judmc_at_sunvaley0.com)
Date: 01/17/04 

Date: Sat, 17 Jan 2004 17:11:29 GMT

"Howard Brazee" <howard@brazee.net> wrote:
>
> "Judson McClendon" <judmc@sunvaley0.com> wrote:
>
> > > 01 My-Date.
> > > 03 My-Day Pic 9(02).
> > > 03 My-Month Pic X(03).
> > > 03 My-Year Pic 9(04).
> >
> > Why would you store a date in such a way?
>
> It is a useful way to display. Almost. If the move to edited field had
> worked, it would have created an unambiguous date in the format that I had to
> use when I was a USAF pilot.
>
> So I suppose the trade off is between not having to do much conversion to
> display the date and between being in a form that is useful for date
> comparisons. The choice would depend upon business needs.

I would rather design for the possibility that you may need to sort or
make relative comparisons on the date at some point, and store it
internally as numeric YYYYMMDD, and convert on output, and input
if necessary. This is more storage efficient and more useful internally.
After some 70+ systems, I have found that it is far better to over design
a system than the reverse. Better to go to extra trouble than have a
design that is insufficiently flexible to support future needs. :-) 

-- 
Judson McClendon      judmc@sunvaley0.com (remove zero)
Sun Valley Systems     http://sunvaley.com
"For God so loved the world that He gave His only begotten Son, that
whoever believes in Him should not perish but have everlasting life."

Relevant Pages

  • Re: Department store self-checkouts run on XP (and they crash)
    ... Here's yet another example of a very poor embedded design that somehow ... out the door. ... So I was at the local department store a few days ago and while using the ... self-checkout, the application completely quit and I was left staring at ...
    (comp.arch.embedded)
  • Re: VB Circle Method Seems to be Seriously Flawed
    ... The best display accuracy you can hope for is +- 1 Pixel. ... > small changes once you're close to the final design. ... > modeling and all are displayed at the same time in the picture box at the ... >> probably know, the underlying objects can be very accurate, and should ...
    (microsoft.public.vb.general.discussion)
  • Mystery CLKDLL, IBUFG, BUFG modules in verilog src (ISE 6.3.03i)
    ... I am using ISE 6.3.03i from Xilinx to load the design onto the ... module seven_seg (CLK, PUSH, DIP, DISPLAY, LED); ... // Register and debounce push buttons and switches ...
    (comp.arch.fpga)
  • Re: Batch Generation of Records
    ... This is one of those cases that if you CAN just store the information about ... your design will have a bunch of code now that has to figure ... appointments like anniversaries.and you only have to add ONE record. ... Also, before and coding gets done, any reason why something like outlook is ...
    (microsoft.public.access.formscoding)
  • Re: PictureBox max width
    ... many seconds of recording and the rate. ... and that's the length of display problem. ... what I don't understand is why you need to store all this ... no need whatsoever to store the actual bitmap that the data produces. ...
    (microsoft.public.vb.general.discussion)