RE: [Talk] firstday and lastday of previous month

Tue, 07 Feb 2006 07:16:51 -0800

Title: firstday and lastday of previous month

Dwight,

 

I have also toiled with those fields.  Here is what I came up with. I run this on the 31st of each month.  I hope it helps.

 

dtBeginDate = Now + 1

dtEndDate = DateSerial(Year(dtBeginDate), 1 + Month(dtBeginDate), 0)

dtBeginDate = DateValue(dtBeginDate)

 

Denise Sebastian

Merle West Medical Center

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shuler, Dwight
Sent: Tuesday, February 07, 2006 7:05 AM
To: [email protected]
Subject: [Talk] firstday and lastday of previous month

 

Hello Everyone,

I am working on an issue with the first day of the previous month and the last day of the preview month and enter those into fields.

I have found some things using the DateAdd function and am working on how to take the now date and  get the first and last day's of last month.

I will post my code once I get it closer to a workable product.  If anyone has some references that would be helpful.

Thanks,
Dwight Shuler

Reply via email to