Calculate final date

[Vandacardoso]

Hi,

I need to calculate the final date based on the begin date and the number of days. The name of the fields are: sdatainicio; diasatribuidos; sdatafim.
Can someone help me?


Regards

[ranman256]

set final date 30 days from sdatainicio...
[final date] = dateAdd("d",30,[sdatainicio])

[IrogSinta]

Have you tried: sdatainicio + NumberOfDays

Ron

[Vandacardoso]

it is not working. I have a field with the number of days.
In my DB I give the begin date, the number of days and then I want the result to be... the final date.
With Your formula I don't have any results at all.

[IrogSinta]

Are you doing this in a query? Can you post the SQL string from the query you created.

[Vandacardoso]

No, is not in a query. I want to put in a Form.

[IrogSinta]

So is it in a Textbox control? If so, just put the either of these expressions in the ControlSource of the textbox:
= [sdatainicio] + [NumberOfDays]
= dateAdd("d",[NumberOfDays],[sdatainicio])

[Vandacardoso]

It works!!!! Thank You IrogSinta! I put the line You wrote.