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
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
set final date 30 days from sdatainicio...
[final date] = dateAdd("d",30,[sdatainicio])
Have you tried: sdatainicio + NumberOfDays
Ron
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.
Are you doing this in a query? Can you post the SQL string from the query you created.
No, is not in a query. I want to put in a Form.
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])
It works!!!! Thank You IrogSinta!I put the line You wrote.