Hi How can I subtract 10 minutes from a date/time value? Thanks Regards
6 '69 Camaro Dec 25, 2006 #2 Hi, John. How can I subtract 10 minutes from a date/time value? Click to expand... Use the DateAdd( ) function with a negative value for the minutes. Try: DateAdd("n", -10, Time()) .. . . which will return the time ten minutes ago. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
Hi, John. How can I subtract 10 minutes from a date/time value? Click to expand... Use the DateAdd( ) function with a negative value for the minutes. Try: DateAdd("n", -10, Time()) .. . . which will return the time ten minutes ago. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.