Report Date Formula

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

Guest

On my report I have a date field in this format yyyymmdd which gets it data
from the table. What I need is for the report to display the date it gets
from the
table and add three days to it.

ie - if the table reads 20061015 - I want the report to display 20061018

I would imagine that I would tweek the format in the date field on the report
but what would I enter.

Thanks - George
 
If you open your table in design view, what is the Data Type of this field?

If it is a Date/Time field, the format is not relevant. You can use
DateAdd() to add whatever you like. For example, if the field is named
MyDate you could set these properties for the text box in your report:
Control Source =DateAdd("d", 3, [MyDate])
Format yyyymmdd
Name txtMyDatePlusThree

If the field is Text or Number, you will need to parse the parts from the
value, using Left(), Mid(), and Right(), add DateSerial() to get a real
date, and then use the DateAdd().
 
What is the name of the field in your table?

What is the name of the text box on your report?

What is in the Control Source of the text box on your report?

What is in the Record Source property of the report?
 
See Below - Thanks

What is the name of the field in your table? PreFlt Date

What is the name of the text box on your report? PreFlt Date

What is in the Control Source of the text box on your report? PreFlt Date

What is in the Record Source property of the report? T-Aircraft Data
Click to expand...
 
As of now the date on the report does show when we completed
the Pre Flight on our aircraft but its due again every 72 hrs or 3 days
so thats why I want to change what the report shows.

Thanks for your time

George
 
George, I can't tell if you saw my original reply to you, suggesting you
change the Control Source of the text box to:
=DateAdd("d", 3, [PreFlt Date])
and also explaining that you need to change the Name of the text box as
well.
 
Allen - That works as we needed. This forum is great.
I'm in the middle east creating a database to track US military
aircraft inspections and you were able to finish the last piece.

Thanks for your efforts.

George

Allen Browne said:
George, I can't tell if you saw my original reply to you, suggesting you
change the Control Source of the text box to:
=DateAdd("d", 3, [PreFlt Date])
and also explaining that you need to change the Name of the text box as
well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

George said:
As of now the date on the report does show when we completed
the Pre Flight on our aircraft but its due again every 72 hrs or 3 days
so thats why I want to change what the report shows.

Thanks for your time

George
Click to expand...
Click to expand...
 
Allen - That works as we needed. This forum is great.
I'm in the middle east creating a database to track military
aircraft inspections and you were able to finish the last piece.

Thanks for your efforts.


Allen Browne said:
George, I can't tell if you saw my original reply to you, suggesting you
change the Control Source of the text box to:
=DateAdd("d", 3, [PreFlt Date])
and also explaining that you need to change the Name of the text box as
well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

George said:
As of now the date on the report does show when we completed
the Pre Flight on our aircraft but its due again every 72 hrs or 3 days
so thats why I want to change what the report shows.

Thanks for your time

George
Click to expand...
Click to expand...
 
Back
Top