Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kenwood1

  1. kenwood1

    Import csv file into Outlook to update Calendar info

    Hi All I have a Leave Calendar in Outlook 2010. I have created a CSV file in excel and I am trying to find some code to Import the file to update Leave Dates. Does anyone have somewhere for me to start. Thanks n advance...
  2. kenwood1

    calculate the months between two dates

    Guys I am probably not explaining myself clearly, we have jobs that are setup with an actual start date say(01/08/2015) and an estimated completion date of say (01/09/2016) and I simply want to count the number of months (as a number) between actual start date and estimated completion date to...
  3. kenwood1

    calculate the months between two dates

    Hi Skip, The actual day is irrelevant, I just need a count of the months..... eg. 08/2015 to 10/2016 is 15 months Ken,
  4. kenwood1

    calculate the months between two dates

    I have a start date (01/08/2015) and an end date (01/09/2016) and I want to know the number of months between them ......
  5. kenwood1

    find occurences of a character in a string

    Thanks andymc & lbass this was the exact solution to my problem, it worked like a dream and 100 times faster than my method. Thanks again guys.
  6. kenwood1

    find occurences of a character in a string

    I am using CR v9 I have long text string that has the data I need separated by a ;. I would like to give each occurence of ; a position number and then use the MID formula to display them on a report. I have used 'Instr' in my attempt, I found the first occurrence and the shortened the string...

Part and Inventory Search

Back
Top