need a Code or equation

[history]

Hello friends

Please if you can help me to find code or equation to calculate the expected birth date.


Data:
For example, an earlier date 20/09/2009 and it will be the first day on the last menstrual period.
And today's date 08/04/2010 for example. the equation will give the gross number of weeks until the deadline day, and expected birth date , which is calculated as follows:
The length of pregnancy is 280 days or we calculate the time limit for delivery in an easy way : to add No. 7 to days and No. 9 to months, to be a time limit for delivery.
In our example: It will be time limit for delivery
20 +7 = 27 and
9 +9 = 6 (because the year 12 months)

Waiting you

 

[pbaldy]

You can use the DateAdd() function to add 280 days to the first date.

 

[history]

Thank you dear friend for your reply
but if you please ,,,, how can I use ?? I mean what to do

Thanks a lot

 

[pbaldy]

I'm not sure what you're asking. You can find the syntax for the function in help. The function can be used anywhere; in a query, in VBA code, or as the control source of a textbox in a form/report.