Re: Passing DateDiff rather than Actual Dates as Parameters

Oops,
I meant:

SELECT @TodayDate = GETDATE()
SELECT @StartDate = DATEADD(DAY,@StartDaysDiff,@TodayDate)
SELECT @EndDate = DATEADD(DAY,@EndDaysDiff,@TodayDate)

.

Relevant Pages

  • Re: How do I add items within the last 12 months?
    ... I do have a column with the date I want to reference to. ... StartDate of period of interest ... EndDate of period of interest ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Count years in date range
    ... I have two columns in a table; one name StartDate, ... EndDate. ... Each table refers to a user and details, obviously, their start ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Concatenating text fields with a WHERE condition
    ... You have to pass the StartDate and EndDate into the function, ... Function fConcatChild(strChildTable As String, _ ... Prev by Date: ...
    (comp.databases.ms-access)
  • Questions on appts collection (Calendar)
    ... I get duplicates (subject, startdate, enddate) sometimes. ... Prev by Date: ...
    (comp.groupware.groupwise)
  • Number of Days in Month
    ... Do While StartDate < EndDate ... Loop ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)