Thread: date field is held as 38932 how do I export as 3rd August 06
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave D Dave D is offline
external usenet poster
  
Posts: 2
Default date field is held as 38932 how do I export as 3rd August 06
I am building up SQL statements using data in a Spreadsheet. I'm doing this
via CONCATENATE. I have a date field that appears to be 3rd August 2006 but
in the concatenate appears as 38932. How do I get it to come through as 3rd
August 2006?
Reply With QuoteReply With Quote