Birthdate 01/01/2000 Remove Slashes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sprowler <Sprowler@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 13 May 2009 08:23:02 -0700

We are trying to remove the slashes in the birthdate field but keep the
leading zero. We have used text to columns to separate the fields, then
converted the columns to text and added any missing zeros, but we can't seem
to get the concatenate field to work after that. There must be an easier
way. Help is appreciated.
.

Follow-Ups:
- RE: Birthdate 01/01/2000 Remove Slashes
  - From: Gary''s Student

Prev by Date: Re: Subtract 10 months from a Speficic Date
Next by Date: sumarize minutes and get the result in hours
Previous by thread: Row height will not auto format
Next by thread: RE: Birthdate 01/01/2000 Remove Slashes
Index(es):
- Date
- Thread

Relevant Pages

Re: How do I remove leading zero in large DB?
... Click on, and drag the break line to separate the data as you wish, then, ... the original column, make sure the code section is selected, and ... my part numbers all have one leading zero. ...
(microsoft.public.excel.misc)
Re: Two questions - thanks!
... > copies of it among the separate objects of the derived classes. ... class One:public Zero{ ... inherit Square and Circle from Shape, but is not elegant to inherit ...
(comp.lang.cpp)
Re: Ground Busses
... it is all very well connecting all grounded leads to a single point but if you then connect that by a single wire to the zero volts point of the power supply you have immediately introduced a long no zero common ground bus. ... of the current loops in the circuit, from power supply out to the signal ... then separate out these loops so they meet at (to the greatest extent ... The problem I see with that is that all output currents must flow from the power supply, through the load and back to the PSU 0V but they share a common ground with the inputs. ...
(rec.audio.tubes)
Re: Lookup fields from various tables
... put the types in separate tables because I needed to record different kinds ... many Organizations and each Organization can have zero, one or many Members). ... If you need to pull names from several tables, ...
(microsoft.public.access.queries)
Re: [PHP] preg_match() returns false but no documentation why
... want but you must escape it in if it appears in the regex. ... The error function may retuyrn 0, but which of the following constants ... Now when I add the slashes, I get zero, even though I give it a real value ...
(php.general)