Hi All,
If I have two dates in a stored procedure, like
@StartDate and @EndDate, if the user puts in any dates for these two parameters, how can I round it to the nearest monday.
Let's say
user inputs:
@StartDate = '06/04/2004' and @EndDate = '06/12/2004'
I want @StartDate ='06/07/2004' and @EndDate = '06/13/2004'.
I can change it so that users can enter only start date also if needed.
Thank you,
Shal
If I have two dates in a stored procedure, like
@StartDate and @EndDate, if the user puts in any dates for these two parameters, how can I round it to the nearest monday.
Let's say
user inputs:
@StartDate = '06/04/2004' and @EndDate = '06/12/2004'
I want @StartDate ='06/07/2004' and @EndDate = '06/13/2004'.
I can change it so that users can enter only start date also if needed.
Thank you,
Shal