Try:
=TEXT(A1,"mm/dd/yy")&" - "&TEXT(B1,"mm/dd/yy")
HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to concantenate 2 dates field together like
1/1/04 & 12/31/04
into 1 field showing 1/1/04 - 12/31/04 but not able to
use the concatenate
function for it convert to data to a number. Any help is
appreciated.
.
|