DateAdd

C

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.

??
 
K

KARL DEWEY

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

y - quanity
 
C

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.

KARL DEWEY said:
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


Calvin said:
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.

??
 
K

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


Calvin said:
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.

KARL DEWEY said:
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


Calvin said:
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.

??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top