Debbie
delam at zyterra.com
Mon Jul 26 16:56:46 CDT 2010
The specs say specifically 60 days so that is probably right. Debbie Sent from my iPhone On Jul 26, 2010, at 3:56 PM, "Gustav Brock" <gustav at cactus.dk> wrote: > Hi Debbie > > No, but as 60 probably means "two months" you may get better results > by using DateAdd("m", 2, Me!DatePicker) > > /gustav > > >>>> delam at zyterra.com 26-07-2010 21:15 >>> > I have an existing app that gets date criteria for a report by adding > 60 to the date. Between me.datePicker and me.datePicker + 60. I am > being asked some very specific questions about when it counts from. My > unfderstanding is that this is a total of 61 days since between is > inclusive. Now I use dateadd() instead of the date + x method. Do > these potentially give different results, say if February or a leap > year is included? > > Debbie > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >