DateAdd

[Calvin]

How would I add a date to a stored date. For instances... I have a log table
that has a bunch of dates I want calculate another date in an upcoming date.

I basically need to know how to input a dateadd formula in a controlbox or
in a query criteria. I know it's DateAdd something. But If I am pulling
information from other tables is it !TableName, !tablename? could you please
give me an example. Say I am pulling from two different tables to make a
calculated value in one field.

??

 

[KARL DEWEY]

DateAdd("x", y, [YourDateField])
"x" ----
yyyy - year
q - quarter
m - month
d - day
h - hour
n - minute
s - second

y - quanity

 

[Calvin]

What if I want to take a date from another field and then add to it. In my
case I am taking a date from a logtable, adding a service interval from
another table, and then I want it to display in a current field.

DateAdd("x", y, [YourDateField])
"x" ----
yyyy - year
q - quarter
m - month
d - day
h - hour
n - minute
s - second

y - quanity

--
KARL DEWEY
Build a little - Test a little

How would I add a date to a stored date. For instances... I have a log table
that has a bunch of dates I want calculate another date in an upcoming date.

I basically need to know how to input a dateadd formula in a controlbox or
in a query criteria. I know it's DateAdd something. But If I am pulling
information from other tables is it !TableName, !tablename? could you please
give me an example. Say I am pulling from two different tables to make a
calculated value in one field.

??

 

[KARL DEWEY]

You can supply the auguments from other tables.

DateAdd([Table_X].[FIELD1], [Table_Y].[FIELD1], [YourDateField])

--
KARL DEWEY
Build a little - Test a little

What if I want to take a date from another field and then add to it. In my
case I am taking a date from a logtable, adding a service interval from
another table, and then I want it to display in a current field.

DateAdd("x", y, [YourDateField])
"x" ----
yyyy - year
q - quarter
m - month
d - day
h - hour
n - minute
s - second

y - quanity

--
KARL DEWEY
Build a little - Test a little

How would I add a date to a stored date. For instances... I have a log table
that has a bunch of dates I want calculate another date in an upcoming date.

I basically need to know how to input a dateadd formula in a controlbox or
in a query criteria. I know it's DateAdd something. But If I am pulling
information from other tables is it !TableName, !tablename? could you please
give me an example. Say I am pulling from two different tables to make a
calculated value in one field.

??