@prompt issue with dates

building reports desktopintelligence
1

HI,
I have a free hand sqlreport where the user has to enter a date and no of days and the no of days has to be added to entered date does the below sql syntax will work requesting for suggestions

declare @start_dt datetime,
@noofdays int,

@start_dt = @prompt(‘Enter the Start date in dd/mm/yyyy’, ‘D’, , mono, free)
select @noofdays int = @prompt(‘Enter the no of days to be added to the start date’, ‘N’ , mono, free)

and
AND INBOUND_MANIFEST.CTD_TMSTMP=dateadd(dd,@nofodays,@start_dt)

Thanks

s7jyothi (BOB member since 2008-09-07)

2

Moderator Note: Please do not open different topics for the same/similar problems. It leads to fragmented discussions and is against our forum rules. Continue here. This is locked.

Jansi :india: (BOB member since 2008-05-12)