Submitted by jan_rifkinson on 2012/06/03 14:26 I've tried various formulations with this but I can't get it working In essence I thought the formula should be something like duedate is 30 days from now but I can't get the syntax right Comments Hi Jan,What have you tried yet ? --------------------------------------------------------------------------------Windows XP Home Edition, Service pack 3Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz Log in or register to post comments In row equation I tried variations of =duedate+now(30)=duedate+now+30 This may be related to the other thread question on due date calculation ??? Log in or register to post comments Try this=duedate+30 (I'm assuming DueDate corresponds to one of your fields)--------------------------------------------------------------------------------Windows XP Home Edition, Service pack 3Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz Log in or register to post comments Thanks Armando. That seems to be working now. Appreciate the help Log in or register to post comments --------------------------------------------------------------------------------Windows XP Home Edition, Service pack 3Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz Log in or register to post comments Log in or register to post comments
Hi Jan,What have you tried yet ? --------------------------------------------------------------------------------Windows XP Home Edition, Service pack 3Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz Log in or register to post comments
In row equation I tried variations of =duedate+now(30)=duedate+now+30 This may be related to the other thread question on due date calculation ??? Log in or register to post comments
Try this=duedate+30 (I'm assuming DueDate corresponds to one of your fields)--------------------------------------------------------------------------------Windows XP Home Edition, Service pack 3Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz Log in or register to post comments
Thanks Armando. That seems to be working now. Appreciate the help Log in or register to post comments
--------------------------------------------------------------------------------Windows XP Home Edition, Service pack 3Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz Log in or register to post comments
Comments