Re: How to store 'time' values?? Date field?
From: DanHW <danhw_at_aol.com>
Date: 03 Aug 1999 05:07:43 GMT
Message-ID: <19990803010743.01161.00002605_at_ng-xc1.aol.com>
Date: 03 Aug 1999 05:07:43 GMT
Message-ID: <19990803010743.01161.00002605_at_ng-xc1.aol.com>
In a similar situation where users entered dates and times, where the time was almost always 5:00pm, but they needed to change the dates frequently, I was actually querying off a view, so I could start with a single DB column and create 2 displayed columns. The procedure that did the insert know how to combine them so they were really only 1 field.
... I wonder if you could replicate this in Forms using mirrored items (both Dates), but with different formats...otherwise you will need to resort to post-query/pre-insert/pre-delete/pre-query triggers.
HTH
Dan Hekimian-Williams
Received on Tue Aug 03 1999 - 07:07:43 CEST