View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
=TEXT(A1,"MM/DD/YY") & " - " & TEXT(B1,"MM/DD/YY")

--
Regards
Frank Kabel
Frankfurt, Germany

Lisa wrote:
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.