To do List
Hello, i am working on Filemaker solution that has to do list . here how it should work .
01. User can see what are the actions he should do in next 7 days and all actions he did in past.
What i did.
I create field called (Today) and used function called Get Today then create another field called todayplus7 and GetAsDate(Today+7). for a instance Today is 25th of January then Today+7 will be 31st of January.
Now I manually enter to find mood and enter this "< 1/31/2012" and perform find , that works perfectly well.
But when i try to make it to script that does not working.
Please refer the snap shot