![]() |
Calculate a suspense date of 90 days.
Hello,
I am trying to figure out how to calculate a suspense date of 90 days from the original date, and if possible send an email alert notifying me of the event. Thanks in Advance, -- Jim Patterson |
Calculate a suspense date of 90 days.
suspense = orgdate + 90
Dates are stored as the elapsed number of days from a base date, so just adding 90 to it should be 90 days later. Ron de Bruin has all kinds of sample code on sending emails: http://www.rondebruin.nl/sendmail.htm -- Regards, Tom Ogilvy "Jim Patterson" wrote in message ... Hello, I am trying to figure out how to calculate a suspense date of 90 days from the original date, and if possible send an email alert notifying me of the event. Thanks in Advance, -- Jim Patterson |
Calculate a suspense date of 90 days.
Got it. Thanks so much,
V/R, -- Jim Patterson "Tom Ogilvy" wrote: suspense = orgdate + 90 Dates are stored as the elapsed number of days from a base date, so just adding 90 to it should be 90 days later. Ron de Bruin has all kinds of sample code on sending emails: http://www.rondebruin.nl/sendmail.htm -- Regards, Tom Ogilvy "Jim Patterson" wrote in message ... Hello, I am trying to figure out how to calculate a suspense date of 90 days from the original date, and if possible send an email alert notifying me of the event. Thanks in Advance, -- Jim Patterson |
All times are GMT +1. The time now is 12:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com