Monday, June 15, 2026
Tip of the Day: New IQTR Function Added
Product: R:BASE 11
Build: 11.0.3.20611 or higher
Section: Functions
Keywords: IQTR, Quarter, Year, Fiscal
A new *IQTR* date function has been implemented to return the fiscal
quarter number for a date, based upon a provided fiscal year beginning date.
*Syntax:*
(IQTR(date,fydate))
Where:
* *date* specifies the date whose quarter you wish to discover
* *fydate* specifies the first day of the fiscal year
The function returns the fiscal quarter number (1,2,3,4).
*Example:*
SET VAR vDate DATE = 06/22/2013
SET VAR vFirstOfFiscalYear DATE = 07/01/2012
SET VAR vIQTR INTEGER = (IQTR(.vDate,.vFirstOfFiscalYear))
The value assigned to vIQTR is 4.
The Support Team
R:BASE Technologies, Inc.
https://www.rbase.com
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/94bb101a-4f03-0c18-556b-a2b9b8083fe9%40rbase.com.
