Adding to a DateAdd

thr33xx

Registered User.
Local time
Today, 02:47
Joined
May 11, 2011
Messages
43
I am attempting to add a specified amount of time (months elapsed) to an already existing value. However when the code executes, it returns values as if it is ignoring the "specified" amount of time which I have bolded below.

Any ideas?

Code:
sql3 = sql3 & ", " & Month(DateAdd("m", I - 1, Me.Add_Dt_First_Subject_Enrolled) + [B](Me.Add_Study_Months_Elapsed)[/B]) & ","
 
Figured it out!

Code:
sql3 = sql3 & ", " & Month(DateAdd("m", I - 1 [B][COLOR="Blue"]+ Me.Add_Study_Months_Elapsed[/COLOR][/B], Me.Add_Dt_First_Subject_Enrolled)) & ","
 

Users who are viewing this thread

Back
Top Bottom