Hi harini. Thanks for the reply. Ive read the link, but it doesn't mention anything about getting the difference between two dates in months :c Hope you have other references.. tnx!

Hi, On microsoft access, we have 2 wild characters, "*" and "?". So the mistake is in using "=" instead of the LIKE. Try to use sentance as: daGuests = new OleDbDataAdapter(string.Format("SELECT * FROM Assignee WHERE SN LIKE '*{0}*'", search), conn); and I hope it will work for you. Manoj

google for "NotesSQL301.exe" and use linked servers to get it working !

got it. thanks! :-D

public static int GetWorkingDatesBetween(DtaeTime DateFrom, DateTime DateTo) { if(DateFrom.CompareTo(DateTo) >= 0 ) throw new ArgumentException("Invalid date ranges! DateTo should be greater than DateFrom"); int totalWorkingDaysElapsed = 0; while(DateFrom.CompareTo(DateTo) != 0) { DateFrom = DateFrom.AddDays(1); if(DateFrom.DayOfWeek == DawOfWeek.Saturday || DateFrom.DayOfWeek == DawOfWeek.Sunday) continue; ++totalWorkingDaysElapsed; } retrun totalWorkinDaysElapsed; } Hope this helps...

Its only an error if the value is a string. If it's a number at any point in the process, the 0s are meaningless, and therefore discarded. You can use string.Format to format a string to have as many zeros as it needs to fit this format. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Colin Angus Mackay wrote: See the documentation for the DateTime and TimeSpan classes tnx! :-D

xibeifeijian ,code works perfectly! thanks alot xibeifeijian and Keshav!!

Sorry, xibeifeijian has it right - it's an instance method, I was just indicating what class it belongs to. Sorry about that :( Sometimes I'm not sure if people will understand I'm speaking in pseudocode; sort of depends on experience level which I don't know up front. Let me know if you need anymore help figuring out how to do the parsing! ------------ Cheers, Patrick