Date between two dates

[Noelie2000]

I'm probably being a wee bit thick but grateful for some assistance.

I am trying to create a formula in a form that works out the date midway between two dates e.g. 1st date 1 Jan 05 2nd date 1 jan 06 formula works out 1 Jul 06 (or thereabouts) and this is then stored in a field.

Any ideas appreciated.

 

[pbaldy]

You could use DateDiff to find the number of days between the 2 dates, divide the result by 2, and add that to the first date using DateAdd. Not sure you should store it though, since it's a calculated value.

 

[Noelie2000]

Thanks. I'll try that and point taken about saving, effectively it would change every year so I will try it as a query formula.

Your a scholar.