Dates

[904allen]

I've copied a fuction by 'D Hargis
Public Function AddWorkDays(OriginalDate As Date, DaysToAdd As Integer) As
Date
I put my tables in and am now trying to make a qrery from my dates table but
i can't get it to work I get a error message telling me that I'm using the
wrong function arguments. Question 1) can I make a qrery using this fuction?
if yes can you help with the correct calcution?

 

[Rick Brandt]

I've copied a fuction by 'D Hargis
Public Function AddWorkDays(OriginalDate As Date, DaysToAdd As
Integer) As Date
I put my tables in and am now trying to make a qrery from my dates
table but i can't get it to work I get a error message telling me
that I'm using the wrong function arguments. Question 1) can I make a
qrery using this fuction? if yes can you help with the correct
calcution?

In order to know if you are using the function correctly we would need to
see how you are using it. How about posting the exact syntax you used.

 

[904allen]

this is one that I attempted
Calcution: DateAdd([OriginalDate],[DaysToAdd])

 

[Rick Brandt]

this is one that I attempted
Calcution: DateAdd([OriginalDate],[DaysToAdd])

Basic diagnostics...

See if it works with constants used intead of both of your fields...

Calcution: DateAdd(Date(),10)

If that works then use one of your fields and one constant...

Calcution: DateAdd([OriginalDate],10)
Calcution: DateAdd(Date(), [DaysToAdd])

Those tests should identify where the problem is.

 

[904allen]

I Got It