Thread: Get long value for a date string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jerry chapman[_2_] jerry chapman[_2_] is offline
external usenet poster
  
Posts: 17
Default Get long value for a date string
I have a date string of 2/21/2005 1:07:22 PM. When I convert it to Long I
get a value of 38405, which is 2/22/2005. How can I make the value be
2/21/2005? Can I truncate the date string to remove the time part?


Reply With QuoteReply With Quote