Skip to main content

Date and Time Expressions
Date and Time Expressions

This section covers everything you need to know about using date and time expressions. It also gives you example knowledge maps so you can explore date and time expressions inside the Rainbird Studio.

In Rainbird, concepts can be ‘date’ concepts.  Date concepts should be used when a date will be either input into or output by Rainbird. Dates in Rainbird are formatted as YYYY-MM-DD (e.g. 1st of March 2021 would be formatted as 2021-03-01).

Rainbird can use date expressions to transform and calculate dates. Date expressions can be combined with other date, transformative and comparative expressions to ‘retrieve’, ‘add’,  ‘subtract’ or ‘compare’ time

If you want to use the outcome of a date expression’s calculation in further calculations, you will need to create the initial date expression on the relationship between the date concept that holds the date concept instances that will be used in the expression, and a number concept which the outcome of the expression will be assigned to.

This section contains the following articles:

0 followers
0 questions
0 posts

You will need to register to be able to post or comment on a topic.  

isBeforeDate / isAfterDate / isSameDate - Downloadable Model

To see isBeforeDate, isAfterDate, and isSameDate expressions in action, run the query on the 'is valid' relationship in the knowledge map generated by the .rbird file.

 

isBeforeDate / isAfterDate / isSameDate - Example Map

This article will demonstrate how to build a map that uses the isBeforeDate, isAfterDate, and isSameDate expressions to let a user know whether a shop voucher is still valid based on the expiration and the redeemed by date of the... (More)

daysBetween / weeksBetween / monthBetween / yearsBetween - Downloadable Model

When viewing the knowledge map generated by the .rbird file below, please see the list below for which query you will need to run to see each date expression in action:

  • daysBetween - 'has days remaining'
  • weeksBetween -... (More)

yearsBetween - Example Map

This article will demonstrate how to build a map that uses the yearsBetween() expression to calculate how many years have passed since the beginning of the millennium. The map will count the number of years between the date the query... (More)

.menu.bell.icon {color: #1c083b;}