Calculate Due Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably an easy question, but I can't seem to figure it out. I have
a date claim received field. I need to calculate the date report due which
is 34 days past the date claim received. I tried creating an unbound field
with the control source equal to [date claim received]+34, but all I get is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?
 
You betch ya.

Brendan Reynolds said:
Do you have an "=" in front of the field name?

=[date claim received] + 34

--
Brendan Reynolds

theitman said:
This is probably an easy question, but I can't seem to figure it out. I
have
a date claim received field. I need to calculate the date report due
which
is 34 days past the date claim received. I tried creating an unbound
field
with the control source equal to [date claim received]+34, but all I get
is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?
Click to expand...
Click to expand...
 
Is the control perhaps also named "date claim received"? If so, try changing
the name of the control.

--
Brendan Reynolds

theitman said:
You betch ya.

Brendan Reynolds said:
Do you have an "=" in front of the field name?

=[date claim received] + 34

--
Brendan Reynolds

theitman said:
This is probably an easy question, but I can't seem to figure it out.
I
have
a date claim received field. I need to calculate the date report due
which
is 34 days past the date claim received. I tried creating an unbound
field
with the control source equal to [date claim received]+34, but all I
get
is
#Name? in the field. The field is on a form that is bound to a table
with
all the information.
Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Check your spelling. That is usually what #Name means. Add a bound object
to [date claim received] then add the = and +34.
This is probably an easy question, but I can't seem to figure it out. I have
a date claim received field. I need to calculate the date report due which
is 34 days past the date claim received. I tried creating an unbound field
with the control source equal to [date claim received]+34, but all I get is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?
Click to expand...
 
This is probably an easy question, but I can't seem to figure it out. I have
a date claim received field. I need to calculate the date report due which
is 34 days past the date claim received. I tried creating an unbound field
with the control source equal to [date claim received]+34, but all I get is
#Name? in the field. The field is on a form that is bound to a table with
all the information.
Any ideas?
Click to expand...

1) Make sure the name of this control is NOT "date claim received".
2) Make sure you have spelled the field name correctly.
3) Is [date claimed received] field a Date datatype field?
4) Did you start the control source expression with an = sign,
i.e. =[date claim received]+34 ?
5 Does =DateAdd("d",34,[date claim received]) work?
 
Back
Top