June 6, 200718 yr I know there are threads for this, but it seems like a lot of work for a simple calculation. All I need to do is take current date subtract 30 days and have the records displayed. I think I will use a portal for that. Looking to create 3 or 4 buttons with 30 60 90 and 120. Click on the button run the script. Is there anyway to take // - # of days? Sorry I am from the Access world and this seems a little strange to me. Sharon
June 6, 200718 yr - use a global number field for the value 30, 60 ... - define two calculation fields 1. get( currentdate ) 2. get( currentdate ) - global_30_or_60_or - define portals relationship as date <= calc_1 AND date >= calc_2 jens
Create an account or sign in to comment