Extract datas

[kazper]

Good day,

I'm trying to extract some data from our database. I just need to get the list of persons that will be having 5 or 10 months on their contract this coming month.


Thanks in advance.

[azimmer]

Good day,

I'm trying to extract some data from our database. I just need to get the list of persons that will be having 5 or 10 months on their contract this coming month.


Thanks in advance.

It is way too little information for us to help. Please include:

• the structure of your relevant tables
• a field-wise description of what you need
• example, perhaps
• the point where you've got by yourself

[Motoma]

How about:
[code=sql]
SELECT
*
FROM
tablename
WHERE
DATEDIFF(MONTH, GETDATE(), datefield) = 5
OR DATEDIFF(MONTH, GETDATE(), datefield) = 10
[/code]