Mar 14, 2014 #1 2009luca Programmer Joined Jul 27, 2013 Messages 231 Location IT Based the current date how to calculate the furst and last day of month -1? Example: now 14/03/2014 calculate first and last day of febrary. Tks.
Based the current date how to calculate the furst and last day of month -1? Example: now 14/03/2014 calculate first and last day of febrary. Tks.
Mar 14, 2014 1 #2 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US hi, Code: dFirst = DateSerial(Year(Date), Month(Date)-1, 1) dLast = DateSerial(Year(Date), Month(Date), 1)-1 Skip, Just traded in my OLD subtlety... for a NUance! Upvote 0 Downvote
hi, Code: dFirst = DateSerial(Year(Date), Month(Date)-1, 1) dLast = DateSerial(Year(Date), Month(Date), 1)-1 Skip, Just traded in my OLD subtlety... for a NUance!