L
le Nordiste
Hello,
I have one query based on a parameter "MyDate".
I enter a full date ( dd/mm/yyyy french format but no matter )
and the query result is expressed by the month ( yyyy_mm)
eg : i enter 25/12/2009 and the result is expressed in
2009_12
I have to run this query for n months before the entered date and 2
months after this date.
Is it possible to get a SQL code for this ?
Can you help me ?
Thanks by anticipation.
I have one query based on a parameter "MyDate".
I enter a full date ( dd/mm/yyyy french format but no matter )
and the query result is expressed by the month ( yyyy_mm)
eg : i enter 25/12/2009 and the result is expressed in
2009_12
I have to run this query for n months before the entered date and 2
months after this date.
Is it possible to get a SQL code for this ?
Can you help me ?
Thanks by anticipation.