For the first day of a month given a date vDate0: SET VAR vDate0 DATE = '01/13/1905' SET VAR vDate1 DATE = (.vDate0 + 1 - (IDAY(.vDate0))) -- and for the last day of the month, move back one day from the first or the next mnth. SET VAR vDate2 = (ADDMON(.vDate1,1) - 1)
SHO VAR vDate% vDate0 = 01/13/05 vDate1 = 01/01/05 vDate2 = 01/31/05 "Warren Glass" <[EMAIL PROTECTED]> wrote: >Buddy, Thanks for the quick response. > >Warren > >-----Original Message----- >From: Walker, Buddy [mailto:[EMAIL PROTECTED]]On Behalf Of Walker, Buddy >Sent: Saturday, November 23, 2002 4:06 PM >To: [EMAIL PROTECTED] >Subject: RE: Date Questions?? > >Warren > �If you already have the month and year then just use the IDWK and RDATE functions > > � �SET VAR v1 = (IDWK((RDATE(.vMonth,1,.vYear)))) > > � With Monday being 1 and Sunday being 7 > >Buddy >-----Original Message----- >From: Warren Glass [mailto:[EMAIL PROTECTED]] >Sent: Sat 11/23/2002 6:50 PM >To: RBase List Server >Cc: >Subject: Date Questions?? >I am given the month and year. �I need to figure the date of the first day >of this month and the date of the last day of this month. Is there a date >function that retrieves the first and last date of a particular month? >Warren > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
