FileMaker

FM0-307 · Question #41

Which formula returns "05-2012" given a date field myDate that contains the date May 20, 2012?

The correct answer is C. Right ("0" & Month (myDate); 2) & "-" & Year (myDate). FileMaker FM0-307 : Practice Test

Architecture and detection capabilities

Question

Which formula returns "05-2012" given a date field myDate that contains the date May 20, 2012?

Options

AGetAsDate (myDate ; "MM-YYYY")
BMonth (myDate) & "-" & Year (myDate)
CRight ("0" & Month (myDate); 2) & "-" & Year (myDate)
DRightWords (Filter (GetAsText (myDate); "xx-xx-xxxx"); 2)

How the community answered

(36 responses)

A
8% (3)
B
3% (1)
C
83% (30)
D
6% (2)

Explanation

FileMaker FM0-307 : Practice Test

Topics

#date formula#string formatting#calculation fields#data manipulation

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full FM0-307 Practice