Thursday, May 30, 2013
Tip of the Day: Defining First and Last Date of the Current Month
Product: R:BASE eXtreme 9.5 (32/64)
Build..: 9.5.2.20521 or higher www.rupdates.com
Section: Functions, Programming
There are times when you may need to provide your users with a pre-defined
first and last date of the month for query and/or reporting purposes.
Did you know that you can dynamically define the first and last date of
the current month by using the following two lines of code:
SET VAR vStartDate DATE = (RDATE((IMON(.#DATE)),1,(IYR4(.#DATE))))
SET VAR vEndDate DATE = ((ADDMON(.vStartDate,1))-1)
The two lines of code above will always calculate the first and last date
of the current month regardless of the current date.
http://www.razzak.com/tips/DefiningFirstAndLastDate.jpg
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
