Stuart McLachlan
stuart at lexacorp.com.pg
Tue Oct 14 16:40:48 CDT 2003
On 14 Oct 2003 at 16:25, Mitsules, Mark wrote: > Oleg_123, > > Thanks for the reply. I went ahead and implemented your > suggestion...setting the destination field format to Short Date. When the > format is set to General Date the previous records do not have a time > component. Does the "Short Date" approach have any negative implications? > Could it cause any impact to date calculations used in criteria? I hope > not... > The display format doesn't have any effect on the underlying data so won't affect date calculations. It can however mislead you into making errors in you criteria. If you are displaying Date/Time records just as a date, you may be fooled into thinking that they only contain date info. If the underlying data is "15 Oct 2003 07:30", you will not get a match if you filter for Date = "15 Oct 2003" If you only want the date part, you should strip off any fractional (time) part when importing the data using Int() -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.