Home : Text Options Tab - Edit/View Variables
Q11296 - INFO: Text Options Tab - Edit/View Variables

Edit/View Variables - Text Options Tab is used to setup the input options for a Text parameter such as drop down list, date entry, etc...

Text Var Format

Text Entry:  This format allows any text to be entered, there is no list defined.  The numeric value for any entry will be 1 (one). 

Drop Down List:  When entering data for this variable the user will be present with a pull down (combobox) with the list.  The numeric value will be the row number of the list item selected (i.e. Partly Sunny will have a numeric value of 2).   The Drop Down List (unlike Drop Down Limit to List) allows users to enter values that are NOT on the list.  Those values store a 1 (one). 

Drop Down Limit to List: When entering data for this variable the user will be present with a pull down (combobox) with the list.  The numeric value will be the row number of the list item selected. The "Limit to List" means only entries allowed will be from the list. 

   
Date Entry: A valid date must be entered.  It will be formatted as mm/dd/yyyy (or dd/mm/yyyy, etc... depending on your Windows regional format).  The numeric value stored will be the Date Serial Number.

Time Entry:  A valid time must be entered. Time can be entered as military time or regular time.  The numeric value stored will be the Date Serial Number.  Note it will set the date portion (integer part) of the date serial number to the date the time is entered for (i.e. if 14:52 entered for Jan 11th, 2021 the numeric value stored will be 44207.62). 

Date/Time Entry: A valid date/time must be entered. The text value will be formatted as mm/dd/yyyy hh:mm AM/PM.  Time can be entered as military time or regular time.  The numeric value stored will be the Date Serial Number.  If Jan 11th, 2021 14:52 is entered the numeric value stored will be 44207.62). 

See Also: Using Text Variables in Calculations and Graphs

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 6/3/2008 3:59 PM.
Last Modified on 1/27/2021 7:55 PM.
Last Modified by Scott Dorner.
Article has been viewed 5252 times.
Rated 8 out of 10 based on 8 votes.
Print Article
Email Article