Date question in MS Access 2

[herd]

If I have two date fields (Date1 and Date2) how would I get a date3 that's between date1 and date2?

Thanks Gary

 

[KenReay]

There may be other ways but

DateAdd("d",(DateDiff("d",Date1,Date2)/2),Date1)

is one way

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PHV]

Or simply this:
Date3 = Date1 + (Date2 - Date1) / 2

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[herd]

When I put both of these codes into my date3 field I get a return of #Name?............what am I doing wrong

 

[KenReay]

Is the control called Date3?, if yes change its name to (say) txtDate3

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK