Search Again: Re: - Question From: Shawn Hogan Date: Friday, August 3, 2001 Time: 7:40:14 pm Michael J. Colvin wrote: > You know what, there is a space there...SO, replace the "" with a " " in > that calculation, and it should work, right? IE: > > If (IsEmpty (Credit Card Exp Date 1), " ", Right ("00" & Credit Card Exp > Date 1, 2)) No... Do this: If (IsEmpty (Credit Card Exp Date 1), "", Right ("00" & Trim (Credit Card Exp Date 1), 2)) - Shawn ------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: - Question by Michael J. Colvin on Aug 3, 2001 at 2:28:28 pm Re: - Question by Joseph Smith on Aug 3, 2001 at 2:43:06 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 2:48:32 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 5:14:20 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 5:18:59 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 5:25:39 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 6:25:34 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 7:05:03 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 7:17:12 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 7:24:53 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 7:38:09 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 7:40:14 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 8:47:18 pm