The simple data types are the ones that the system typically uses in comparisons
- Bool: Is a so called boolean type typically used in true/false conditional statements.
(ie. [If (CurrentBooking!null)]The meeting room is busy[If (CurrentBooking.HasChanges=true)] .. and changes have been made on it.[end if][end if])
- Integer: Is a positive or negative integer number.
(ie. [CurrentBooking.ClientName] has [CurrentBooking.RepetitionNumber + 1] years anniversary today.)
- Decimal: Is a positive or negative decimal number.
(eg. this product costs $[Format(”0.00”, product.price)].)
- Datetime: Is a time and date type, i.e. it contains both. All times in the booking system are in a neutral time format (UTC) which is converted on the fly. So, if an event is set up in Greenland and is to be displayed on a screen in Copenhagen, the info screen in Copenhagen does not need to know anything about the time zone in Greenland to express the time according to the time zone in Copenhagen. Use the FormatDate command to format time and dates — it automatically converts to the current time zone.
(eg. The event starts on[FormatDate(”D”, CurrentBooking. DateFrom)] at [FormatDate(”t”, CurrentBooking. DateFrom)].)
- String: Is any text string. When you want data to be displayed, it is always converted to a text string. In HTML, this sometimes presents challenges when character sets collide, therefore it is recommended to use the SafeXml() command in case that text strings may contain special characters
(ie. Daily Tasks, see [SafeXml(CurrentBooking.Description)].)