FileMaker
FM0-307 · Question #89
Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?
The correct answer is C. Ceiling (Month (myDate) / 3). See the full explanation below for the reasoning.
Question
Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?
Options
- AInt (Month (myDate) / 3)
- BMod (Month (myDate); 3) + 1
- CCeiling (Month (myDate) / 3)
- DLet (m = Month (myDate) ;
- ELet (m = Month (myDate) ;
How the community answered
(33 responses)- A6% (2)
- C79% (26)
- D3% (1)
- E12% (4)
Community Discussion
No community discussion yet for this question.