How to display dates from today on wards by omitting the ones that have passed in table box

[#1]

Hi

I have a list of dates that have past and the ones that are still coming,but i need to see list of date that have not yet past in a table box object  with names of people.e.g the date i want to see is today onward

2015/09/23,

2015/08/03,

2015/11/16,

2015/11/20,

2015/11/23

2015/12/03

your feedback will be highly appreciated

Thanks and Regards

Priscilla

[sunny_talwar]

I don't think it would be possible to do this in a table box, but you should be able to do it in a straight table or pivot table

[#3]

the reason i am choosing the table box its because  i am not doing any calculation,I just need the table to display date that are due from today as well as their matching names.I did this on the scrips but it is  retaining the Closing date as it is in the if statement instead due date .please help I dont know if I am doing the correct thing i mean the script

[Due Date]:

Load

if ([Closing date] >= Today(2),'[Closing date]' ) as Due_Date

Resident Customer ;

[sunny_talwar]

Instead of doing it for the field, use a Where statement to restrict:

[Due Date]:

LOAD

[Closing date] as Due_Date

Resident Customer

Where [Closing date] >= Today();

[#5]

Hi Sunny

Thank you very mach. it is doing exactly what I wanted thank you.

and Good Day

[sunny_talwar]

Awesome

Would you be able to close this thread in that case.

Best,

Sunny

[#7]

How do I close it

[sunny_talwar]

You need to select Correct Answer