Features
Pricing
Support
News
Contact us
Log in

Log in

Documentation
Templates
Training
Webinars
Consulting

Features

Form designer
Report designer
Integrations
Data entry
All features
New features

Pricing

Subscriptions
Onboarding
Partnerships

Support

Documentation
Templates
Training
Webinars
Consulting

News Contact us

Support
Documentation
Formulas
Date & Time Functions

Date & Time Functions

TODAY
DATE
ADDDATE
DAY
MONTH
QUARTER
YEAR
DAYS
YEARFRAC

Formulas

Logical Functions

AND (&&)
OR (||)
IF
NOT (!)
EQUAL (==)
NOT EQUAL (!=)
GREATER (>)
GREATER OR EQUAL (>=)
LESS (<)
LESS OR EQUAL (<=)
ISNUMBER
ISBLANK

Text Functions

SEARCH
CONCAT
LEFT
RIGHT
MID
REGEXMATCH
REGEXREPLACE
REGEXEXTRACT
VALUE

Date & Time Functions

TODAY
DATE
ADDDATE
DAY
MONTH
QUARTER
YEAR
DAYS
YEARFRAC

Statistical Functions

SUM
AVERAGE
MEDIAN
MAX
MIN
COUNT
COUNTDISTINCT

Mathematical Functions

ADD (+)
SUBTRACT (-)
MULTIPLY (*)
DIVIDE (/)
CEIL
FLOOR
POWER
GREAT_CIRCLE

COALESCE

ActivityInfo

About us
ISO 27001 & Information Security
News and stories
Partnerships
Careers

Contact us

Resources

Case studies
Documentation
Self-managed Server Guide
Webinars
API guide
Release notes

Use cases

Monitoring & Evaluation
Humanitarian coordination
Case Management

Key features

Mobile data collection
Data entry
Data management
Data analysis and visualization

Server status
Terms of service
Privacy policy

Join our LinkedIn Group or follow ActivityInfo