Code for getting the next "the 1st in month"

Thread Rating:

Thread Modes

Code for getting the next "the 1st in month"

manabh Offline

Member

Posts: 61
Threads: 1
Joined: Jul 2009
Reputation: 0

10-21-2009, 07:24 PM

Hi,
Try this...

Code:
Dim TmpDate, NewDate

   TmpDate = DateAdd("mm", 1, Date)

   NewDate = DateSerial(Year(TmpDate), Month(TmpDate), 1)

Find

« Next Oldest | Next Newest »

Messages In This Thread

RE: Code for getting the next "the 1st in month" - by manabh - 10-21-2009, 07:24 PM

Users browsing this thread: 3 Guest(s)