QUARTER( ) Returns the quarter number for a specified date value. Syntax QUARTER(date) Arguments date The date or date expression whose quarter number to get. Returns A number from 1 to 4 representing the quarter for a specified date value. Quarter 1 starts in January. Example The following example displays the quarter number for each value in the CloseDate data field: QUARTER([CloseDate]) The following example displays a string—Q1, Q2, Q3, or Q4—for each value in the CloseDate data field: "Q" & QUARTER([CloseDate])
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy