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

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

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

Thanks a lot

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.