DateAdd

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Calvin - 17 Oct 2007 15:36 GMT

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.

??

Reply to this Message

KARL DEWEY - 17 Oct 2007 16:08 GMT

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

y - quanity

Signature

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.
[quoted text clipped - 6 lines]
>
> ??

Reply to this Message

Calvin - 17 Oct 2007 16:21 GMT

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" ----
[quoted text clipped - 18 lines]
> >
> > ??

Reply to this Message

KARL DEWEY - 17 Oct 2007 17:31 GMT

You can supply the auguments from other tables.

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

Signature

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
[quoted text clipped - 22 lines]
> > >
> > > ??

Reply to this Message