OK - I have a problem - other than mental ;-)
I am creating a query in SQL that will look ahead to see what documents are due to be completed.
If I do the math of a 30 60 90 day look ahead from the present date - it works fine.
HOWEVER, they want to be able to enter the number of days that it will look ahead. I have tried to define a variable in the query and keep getting syntax errors.
How do I create this variable, prompt for the input and add the number to the current date.
Everything I have tried, researched and gleaned from various posts has not provided the answer I need.
Your time and help is appreciated. Im Steven B
I am creating a query in SQL that will look ahead to see what documents are due to be completed.
If I do the math of a 30 60 90 day look ahead from the present date - it works fine.
HOWEVER, they want to be able to enter the number of days that it will look ahead. I have tried to define a variable in the query and keep getting syntax errors.
How do I create this variable, prompt for the input and add the number to the current date.
Everything I have tried, researched and gleaned from various posts has not provided the answer I need.
Your time and help is appreciated. Im Steven B