Post reply

Only including data greater than today

  • March 10, 2015 at 10:33 am

    #301942

    Hi guys,

    I have this parameter created

    =iif(WeekDayName(WeekDay(today())) = "Friday",dateadd("d",3,Today()),dateadd("d",1,Today()))

    However what this is doing currently is pulling through all data.

    I only to want to see the data which is either a day ahead, or when it hits Friday I want to see all data on the following 3 full days.

    Any idea as to how I can get around this?

    Thanks in advance.

  • March 11, 2015 at 10:12 am

    #1783371

    david5515 (3/10/2015)

    Hi guys,

    I have this parameter created

    =iif(WeekDayName(WeekDay(today())) = "Friday",dateadd("d",3,Today()),dateadd("d",1,Today()))

    However what this is doing currently is pulling through all data.

    I only to want to see the data which is either a day ahead, or when it hits Friday I want to see all data on the following 3 full days.

    Any idea as to how I can get around this?

    Thanks in advance.

    Are you filtering the table with the expression, or the dataset query? if you do either of those things, it should show correctly.

    Parameters themselves don' filter data. They have to be used in a query or expression to filter.

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

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