Post reply

If Thursday show Friday, Saturday and Sunday else show tomorrow

  • September 27, 2019 at 2:13 pm

    #3684047

    Hi all,

    I have found the below and i was wondering how I could change it.  I want to be be able to always show the the next days data unless it is a Thursday. If its Thursday then show Friday, Saturday and Sunday of next week.

    Thanks in advance

    DECLARE @StartDate date;
    DECLARE @EndDate date;
    --set start date as yestreday unless today is Monday then show Friday
    SET @StartDate = CASE DATEPART(WEEKDAY, GETDATE()) WHEN 2 THEN DATEADD(DAY, -4, GETDATE())
                                                              ELSE DATEADD(DAY, -1, GETDATE()) END;

    -- set end dates AS TODAY
    SET @EndDate = GETDATE();

  • September 27, 2019 at 2:23 pm

    #3684051

    I don't understand this part:

    If its Thursday then show Friday, Saturday and Sunday of next week.

    How can all three days be 'shown' simultaneously?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply