[AccessD] DateAdd vs +

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
>



More information about the AccessD mailing list