Report Date Formula

[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

 

[Allen Browne]

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().

 

[Guest]

I tried your formula and it gives me an error message on report, still trying.

George

 

[Guest]

I am using Date/Time Field in table

 

[Allen Browne]

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?

 

[Guest]

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

 

[Allen Browne]

Well, that won't give you 3 days from the PreFlt Date, will it?

 

[Guest]

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

 

[Allen Browne]

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.

 

[Guest]

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

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.

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

 

[Guest]

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.

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.

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