Questions and CORRECT Answers
& - CORRECT ANSWER - Concatenation. Using " & " to join text together either in " "
or inside a data item.
StartsWith() Function - CORRECT ANSWER - Function that takes 2 separate values and
compares them. I.E StartsWith("Example", "ple") will return FALSE "Exa" will return TRUE.
EndsWith() Function - CORRECT ANSWER - Function that takes 2 separate values and
compares them. I.E EndsWith("Example", "ple") will return TRUE "Exa" will return FALSE.
Mid() Calculation - CORRECT ANSWER - Gets text taken from the middle of the text
expression.
Start point is a numerical value to give the starting position.
Length is how many characters from the starting position you would like to include.
Left() Function - CORRECT ANSWER - Gets text taken from the left of a text expression
I.E Left("Example", 3) = "Exa"
Right() Function - CORRECT ANSWER - Gets text taken from the Right of a text
expression Right("Example", 3) = "ple"
Trim Function - CORRECT ANSWER - Removes blanks and empty spaces in text data
item.
ToNumber() - CORRECT ANSWER - Converts text value to a number
, & " " - CORRECT ANSWER - Ampersand w/ quotation marks converts a number to a text
[Number] & ""
ToDate() Function - CORRECT ANSWER - Converts a value to a date.
ToDateTime() Function - CORRECT ANSWER - Converts a value to a datetime. Default
is 12:00:00
ToDays(TimeSpan) Function - CORRECT ANSWER - Converts a TimeSpan to a whole
number of days, rounded down.
ToHours(TimeSpan) Function - CORRECT ANSWER - Converts a timespan to a whole
number of hours, rounded down.
ToMinutes(TimeSpan) Function - CORRECT ANSWER - Converts a timespan to a whole
number of minutes, rounded down.
DateAdd(Interval, Number, Date) - CORRECT ANSWER - Gets a date with a number of
intervals
Intervals - CORRECT ANSWER - 0 - Year
1 - Full Week
4 - Quarter (4 Quarters in a Year)
5 - Month
9 - Day (9th Day of Christmas)
DateDiff() - CORRECT ANSWER - Gets the difference between 2 dates
FormatDate() - CORRECT ANSWER - Formats a date to any format assigned within its
boundaries