Home : EOS
Q10622 - INFO: EOS

EOS the ending of the Variable's or VarType Time slot as a DateTime.

SYNTAX:

EOS(VarNum/VarType,Date,Format) 

VarNum/VarType:  If the field is numeric it is assumed to be a variable number, if it is text it is assumed to be a Variable Type. 

Date: The datetime that you want to find the start time for.   This field can be a string representing a valid date, i.e. "1/2/2004 13:15", a cell reference to a cell containing a date string, or a function that returns a date string.

Format: The date format for the result. 

EXAMPLES:

EOS("H","1/23/2008 13:22","mm/dd/yyyy hh:mm") - Returns "01/23/2008 14:00".  For an Hourly variable (specified by the ""H") with a time of 13:22 the slot is 13:00 thru 13:59:59.  

EOS(2,"1/23/2008 13:22","mm/dd/yyyy hh:mm") - Returns "01/23/2008 14:00".  For an Hourly variable (Variable number 2 is an hourly parameter) with a time of 13:22 the slot is 13:00 thru 13:59:59.  

Download Example Template: Help_BOS_EOS.ss3 (Click here for download instructions)

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 1/11/2008 2:34 PM.
Last Modified on 10/21/2008 3:22 PM.
Last Modified by Jan Bob.
Article has been viewed 2938 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article