View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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.
.