Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default date query

I have dates in the format yyyy-mm-dd. How do I get VB to convert these into
date format? I want to use the dates in a calc to determine the number of
months between 2 dates

eg 2007-06-19 and 1995-09-01


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date query Crimson King Excel Worksheet Functions 4 October 24th 07 01:54 AM
Date Query Treza Blu Excel Discussion (Misc queries) 4 May 31st 07 09:11 PM
Query Latest Date Mack Neff Excel Discussion (Misc queries) 1 April 26th 07 07:42 PM
Date query? Harley Excel Discussion (Misc queries) 2 May 11th 06 11:31 AM
How do I enter a date range ie -7 from current date in MS QUERY notsmartenough Excel Discussion (Misc queries) 1 November 11th 05 10:17 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"