Field Update

This topic is locked

Field Update	5/18/2011 1:27:50 PM
ASPRunnerPro General questions
A azmi author I am a DBA not a programmer but use ASP runner for a long time without any programin skill. But Now I need help, If somebody can help me. My senario is as follow: Table Name "Schedule" Fld1 = 1st meeting date fld2 = 2nd meeting date fld3 = 3rd meeting date I want when somebody enter 1st meeting Date then 2nd meeting date automatically update with 1st meet date + 45 day and 3rd meeting date update to 1st meeting date + 90 days. Thanks in Advance Azmi


M	Maurits 5/19/2011
	I am a DBA not a programmer but use ASP runner for a long time without any programin skill. But Now I need help, If somebody can help me. My senario is as follow: Table Name "Schedule" Fld1 = 1st meeting date fld2 = 2nd meeting date fld3 = 3rd meeting date I want when somebody enter 1st meeting Date then 2nd meeting date automatically update with 1st meet date + 45 day and 3rd meeting date update to 1st meeting date + 90 days. Thanks in Advance Azmi If you use the date as a text field in the database use Cstr(). If it is a date field use without Cstr() AddDay = Cstr(CDate(DateAdd("d", +45, Date()))) TotalDaysThisMonth = DateDiff("d", Now, "19/05/2011") Give it a try