Fordraiders
asked on
for dates in query need equivalent to sql server syntax
In the query below,
on the where statement. is there a method the same as "datediff"
WHERE ((DateDiff('d',[date_propo sal_comple ted],Date( ))<+30) AND ((dbo_temp_proposal_survey _results.w l_status) Is Null));
I need to change this syntax to sql server syntax. Please.
Thanks
fordraiders
on the where statement. is there a method the same as "datediff"
WHERE ((DateDiff('d',[date_propo
I need to change this syntax to sql server syntax. Please.
SELECT dbo_temp_proposal_survey_results.proposal_id, dbo_temp_proposal_survey_results.specialist_responsible, dbo_temp_proposal_survey_results.customer_name, dbo_temp_proposal_survey_results.date_proposal_completed, dbo_temp_proposal_survey_results.seller_racf_id, dbo_temp_proposal_survey_results.seller_email, dbo_temp_proposal_survey_results.wl_emailed_on, dbo_temp_proposal_survey_results.wl_survey_completed_on, dbo_temp_proposal_survey_results.wl_status, dbo_temp_proposal_survey_results.wl_Q1_answer, dbo_temp_proposal_survey_results.wl_Q2_answer, dbo_temp_proposal_survey_results.wl_Q3_answer, dbo_temp_proposal_survey_results.wl_Feedback, dbo_temp_proposal_survey_results.wl_ReasonLoss
FROM dbo_temp_proposal_survey_results
WHERE ((DateDiff('d',[date_proposal_completed],Date())<+30) AND ((dbo_temp_proposal_survey_results.wl_status) Is Null));
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all..
Yep. That would be DATEDIFF.