Loading lesson path
Concept visual
Start at both ends
A list of all field look up keywords:
Formula
Same as contains, but case - insensitive dateFormula
Matches a date (day of month, 1 - 31) (for dates)endswith
Formula
Same as endswidth, but case - insensitive exactFormula
Same as exact, but case - insensitive inGreater than, or equal to hour Matches an hour (for datetimes) lt
Less than, or equal to minute Matches a minute (for datetimes) month Matches a month (for dates) quarter
Formula
Matches a quarter of the year (1 - 4) (for dates)range
Formula
Same as regex, but case - insensitive secondMatches a second (for datetimes) startswith
Formula
Same as startswith, but case - insensitive timeMatches a time (for datetimes) week
Formula
Matches a week number (1 - 53) (for dates)week_day
Formula
Matches a day of week (1 - 7) 1 is Sunday iso_week_day
Matches a ISO 8601 day of week (1 - 7) 1 is Monday yearMatches a year (for dates) iso_year Matches an ISO 8601 year (for dates)