Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to Pass Current Date As End Date In SQL Pramaeters

Hi All

I am using stored procedure in Crystal reports it has start date and end date

with out  using sub report how can i pass end date as current date  in SQL Command line

in Crystal reports

Please Advise

Thanks

Krishna M

Tags:
Former Member
Former Member replied

Hey Thanks abhilash with you support only it is possible  did some small modifications to the stored procedure

found the solution

DECLARE @GetDateValue datetime;

SET @GetDateValue = GetDate();

Exec [dbo].[cr_projects] 'IND','01/01/2015', @WeekEndDate = @GetDateValue;

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question