Jump to Content
FulcrumSupportFeedbackChangelog
Developer GuidesAPI ReferenceAnnouncements
SupportFeedbackChangelogLog InFulcrum
Log In
Developer GuidesAPI ReferenceAnnouncements

DOCUMENTATION

  • Developer Information
    • Webhooks
    • Data Shares
    • URL Actions
    • Desktop Sync

CALCULATIONS

  • Calculations Reference
    • ABS
    • ACOS
    • ACOSH
    • ALTITUDE
    • AND
    • ARRAY
    • AVERAGE
    • CEILING
    • CHAR
    • CHOICEVALUE
    • CHOICEVALUES
    • CLEAN
    • COALESCE
    • CODE
    • COMPACT
    • CONCAT
    • CONCATENATE
    • CONTAINS
    • COS
    • COSH
    • COUNT
    • COUNTA
    • COUNTBLANK
    • DATANAMES
    • DATE
    • DATEADD
    • DATEVALUE
    • DAY
    • DEGREES
    • DESCRIPTION
    • DEVICEINFO
    • DEVICEMANUFACTURER
    • DEVICEMODEL
    • DOLLAR
    • EMAIL
    • EVEN
    • EXACT
    • EXISTS
    • EXP
    • FACT
    • FACTDOUBLE
    • FALSE
    • FIELD
    • FIELDNAMES
    • FIELDS
    • FIELDTYPE
    • FIND
    • FIRST
    • FIXED
    • FLATTEN
    • FLOOR
    • FORM
    • FORMAT
    • FORMATADDRESS
    • FORMATNUMBER
    • GCD
    • GETRESULT
    • GROUP
    • HASOTHER
    • IF
    • INSPECT
    • INT
    • ISBLANK
    • ISEVEN
    • ISLOGICAL
    • ISMOBILE
    • ISNAN
    • ISNEW
    • ISNONTEXT
    • ISNUMBER
    • ISODD
    • ISROLE
    • ISSELECTED
    • ISTEXT
    • ISUPDATE
    • LABEL
    • LAST
    • LATITUDE
    • LCM
    • LEFT
    • LEN
    • LN
    • LOG
    • LOG10
    • LONGITUDE
    • LOWER
    • LPAD
    • MAX
    • MAXA
    • MEDIAN
    • MID
    • MIN
    • MINA
    • MOD
    • MONTH
    • NOT
    • NUM
    • NUMS
    • ODD
    • ONCE
    • OR
    • OTHER
    • PI
    • PLATFORM
    • PLUCK
    • POWER
    • PRECISION
    • PRODUCT
    • PROJECTID
    • PROJECTNAME
    • PROPER
    • QUOTIENT
    • RADIANS
    • RAND
    • RANDBETWEEN
    • RECORDID
    • REPEATABLEID
    • REPEATABLENUMBER
    • REPEATABLESUM
    • REPEATABLEVALUES
    • REPLACE
    • RIGHT
    • ROLE
    • ROUND
    • ROUNDDOWN
    • ROUNDUP
    • RPAD
    • SEARCH
    • SETRESULT
    • SHOWERRORS
    • SHUFFLE
    • SIGN
    • SIN
    • SINH
    • SORT
    • SQRT
    • SQRTPI
    • STATUS
    • STATUSLABEL
    • STRING
    • SUBSTITUTE
    • SUM
    • SUMSQ
    • TIMEADD
    • TIMEDIFF
    • TIMESTAMP
    • TIMEZONE
    • TRIM
    • TRUE
    • TYPEOF
    • UNIQUE
    • UPPER
    • USERFULLNAME
    • VALUE
    • VERSIONINFO
    • YEAR
  • Examples

DATA EVENTS

  • Data Events Reference
    • ALERT
    • CLEARINTERVAL
    • CLEARTIMEOUT
    • CONFIRM
    • CURRENTLOCATION
    • INVALID
    • ISLANDSCAPE
    • ISPORTRAIT
    • MESSAGEBOX
    • OFF
    • ON
    • OPENURL
    • PROGRESS
    • PROMPT
    • REQUEST
    • SETCHOICEFILTER
    • SETCHOICES
    • SETDESCRIPTION
    • SETFORMATTRIBUTES
    • SETHIDDEN
    • SETINTERVAL
    • SETLABEL
    • SETLOCATION
    • SETMAXLENGTH
    • SETMINLENGTH
    • SETPROJECT
    • SETPROJECTHIDDEN
    • SETPROJECTREADONLY
    • SETREADONLY
    • SETREQUIRED
    • SETSTATUS
    • SETSTATUSFILTER
    • SETSTATUSHIDDEN
    • SETSTATUSREADONLY
    • SETTIMEOUT
    • SETVALUE
    • STORAGE
  • Examples

REPORT BUILDER

  • Introduction
  • Examples

YEAR

Suggest Edits

Returns the year of a given date.

Parameters

date Date (required) - a date

Returns

Number

Examples

YEAR("2015/1/1")

// returns 2015

Updated almost 2 years ago


Did this page help you?
  • Table of Contents
    • Parameters
    • Returns
    • Examples