Need Help on Straight Table filteration

[#1]

Need help in Straight table filter

I have a column called Report_Date which is having dates  in it . I need to generated a straight table which will show me next 5 days Report_Date column data from today onwards . Say today date is 23rd April 2015 so it should show only those records starting from today to 28th April 2015 in straight table.

[maxgro · Accepted solution]

with this script

load

  date(makedate(2015) +floor(rand()*365)) as reportdate,

  rand()*10 as exp

AutoGenerate

  1000;

use this expression

sum({$<reportdate={">=$(=Today())<=$(=date(num(Today())+5))"}>} exp)