BEFORE

Description

BEFORE takes two dates, and checks if the first one comes before the second.

‚Äč

Example

BEFORE(e.date_of_founding, e.date_of_domicile)

This expression checks whether a company was founded before it gained its current country of domicile. If the expression evaluates to 'true', the company was founded in a different country than where it is currently domiciled.