Search Again: Re: ugh Cleanup! From: Shawn Hogan Date: Tuesday, October 3, 2000 Time: 10:29:34 am Matt Bailey wrote: > OK This is a mistake on the import when my partner imported the time he did > it as mm/dd/yyyy hh:mm:ss Is there a way to strip that hours minutes > seconds off in the database? (only a couple thousand entries with it :) Well, I have not tried it (so backup first if you do it), but you could do a calculated replace on that field as: LeftWords (FieldName, 3) - Shawn ------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 ------------------------------------------ To subscribe, unsubscribe and list archive please visit http://www.optigold.com/lists ------------------------------------------

Messages In This Thread: ugh Cleanup! by Matthew Bailey on Oct 3, 2000 at 8:55:51 am Re: ugh Cleanup! by Shawn Hogan on Oct 3, 2000 at 10:29:34 am