Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ;
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();
Hi Sunny
Thank you very mach. it is doing exactly what I wanted thank you.
and Good Day
Awesome
Would you be able to close this thread in that case.
Best,
Sunny
How do I close it
You need to select Correct Answer