What is the keyword to use?
In order to create a timespan type control, please use one of the following keywords:
Description | Keyword to Use |
Time duration | timespan |
Why use this keyword?
With this control, you will be able to:
Get a result in days, hours and/or minutes
You can only compare two dates and/or times fields/columns (Julian date included)
You can only subtract one another
You need to compare the same keywords
You will get negative results based on the order of your formula:
End - Start = Positive result
Start - End = Negative result
Keyword #1 | Keyword #2 | Timespan result |
date | date | {0} days |
time | time | {0} hours {0} minutes |
datetime | datetime | {0} days {0} hours {0} minutes |
juliandate | juliandate | {0} days |
juliandatewithyear | juliandatewithyear | {0} days |
How to use this keyword?
As a FIELD
Using columns A, B and C in the Excel spreadsheet, you can create a field.
Column A will be used for the TITLE
The title will be displayed to add a description regarding your input;
Column B will be used for the KEYWORD
The keyword defines what the field will be used for;
Column C will be used for the VALIDATION RULE(S)
Optionally, you can add the validation rules to:
specify a limit,
add formulas;
automate a targeted field, such as making it display a certain value;
change the state of a field;
Here is an example:
Here is how it displays in the application:
As a COLUMN
Using three consecutive rows (or as we refer to it, 123) in the Excel spreadsheet, you can create a column.
Row 1 will be used for the TITLE
The title will be displayed to add a description regarding your input;
Row 2 will be used for the KEYWORD
The keyword defines what the column will be used for;
Row 3 will be used for the VALIDATION RULE(S)
Optionally, you can add the validation rules to:
specify a limit,
add formulas;
automate a targeted column, such as making it display a certain value;
change the state of a column;
Here is an example:
Here is how it displays in the application:
