[AccessD] DateAdd vs +

Gustav Brock gustav at cactus.dk
Mon Jul 26 15:56:50 CDT 2010


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





More information about the AccessD mailing list