Search results for query: *

Thanks! It worked!

How do you write the code to compare to the entire date ... month,day and year? This didn't work for me ... WHERE Datediff (YYYYMMDD,birth_date , hire_date) >=60 thanks, stacy

Thanks!

Right, because of the operator: >=, which means 'greater than or equal to'. Thanks! :)

Thanks so much! I'm an intermediate coder ... Am I understanding the logic correctly? Select everything WHERE the difference between two dates, looking at the last 2 digit year of (birth_date) then (hire_date) is => 60?

Please help someone, it's pretty urgent ... :(

Sorry about that. It returns data if I use <= 60. So this tells me that my code is still incorrect. In the return, I see someone who is 29 years old. This person should not be listed in the return. I only want those who are 60 years old or older on their hiredate based off of their...

It's not returning data. SELECT birth_date ,hire_date ,RTRIM(last_name) AS LastName ,RTRIM(first_name)AS FirstName ,empno FROM empper WHERE Datediff (y,hire_date , birth_date) >= 60 --("empper"."birth_date") -("empper"."hire_date") < '1951' ORDER BY last_name

How do I get those employees who were 60 years old at date of hire? the date format is: 2002-10-16 00:00:00.000 Here's that I have and it is returning everyone: SELECT hire_date ,birth_date ,RTRIM(last_name) AS LastName ,RTRIM(first_name)AS FirstName ,empno FROM empper WHERE...

Thanks! I found the mistake late yesterday. I did have MAX in the date conversion code. Once I removed it, it worked perfectly. Thanks!

I'm getting the following error message: Msg 8120, Level 16, State 1, Line 1 Column 'empper.emp_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Here's my code ... what am i doing incorrectly? Thanks .... SELECT...

- It's Word 2007. - Yes, I've tried many times to right click on the toc field and choosing to update the field. It's apparent that it's not the fix. I - It's 3 levels as I stated previously. My levels are according to my style choice: My document title = Heading1 My document subtitle =...

I've created a table of contents many times before. This is what I have done: 1. I have identified my "title" as "Heading1" 2. I have identified my "subtitle" as "Heading2" 3. I have identified my "sub-subtitle" (not sure if that's correct wording, but hopefully you will get the point) as...

Thanks! I'll try it.

I am in the process of learning to use vb.net. I have an ansi sql database that I want to connect in my vb.net solution. I tired several times but have been unsuccessful. My laptop that I am using is not using a SQL server. Do I need a sql server access in order to access the dbf in vb.net...

Thanks sooo much. Here's a solution that was found. It consisted of writing the code, "UPPER". BUT ... believe me, your help is not in vail. I have soooo much to learn. The basic concept is easy, it's just knowing how to write it to get it to work .... Can you suggest how you learned to...

Thanks so much! ;)

I am so clueless. Can you assist me in writing the code correctly? I am new to FoxPro 2.6 and learning to write the code. So sorry and thanks so much

I tried but it didn't work. What did I do wrong? Here's the code: GOTO TOP SET NEAR ON SET EXACT OFF IF m.find = 1 AND NOT EMPTY(m.findthis) SELECT * ; FROM bashproc ; WHERE bashproc.task = ALLTRIM(m.findthis) ; INTO CURSOR pickone IF _tally > 0 && I found at least...

Yes, it is: ALLTRIM(task)+DTOC(compdate) Thanks!