merge unformatted date with text
 

My original date column was formatted 02/01/71. I created a new column and
created a custom date format; 020171. I would like to take this column and
merge it together with the last 3 digits of a column where a ss# resides.
This column is a text column. For example, the new column should look like
020171008. Can anyone help?

I tried this based on your example and used the =Text
(originaldate,mmddyy) function and used a =Right(ss#,3) to
create a new column for the last three of the ss#. Then
Concatenated the two fields resulting in 02171999.

Good Luck!



-----Original Message-----
My original date column was formatted 02/01/71. I
created a new column and
created a custom date format; 020171. I would like to
take this column and
merge it together with the last 3 digits of a column
where a ss# resides.
This column is a text column. For example, the new
column should look like
020171008. Can anyone help?
.

you may also do a =Concatenate(converted date,Right(ss#,3))



-----Original Message-----
My original date column was formatted 02/01/71. I
created a new column and
created a custom date format; 020171. I would like to
take this column and
merge it together with the last 3 digits of a column
where a ss# resides.
This column is a text column. For example, the new
column should look like
020171008. Can anyone help?
.