Home : HDATA
Q13197 - INFO: HDATA
HDATA returns values for an hourly variable.  Function is obsolete and has been replaced by DDV.  It is still supported for backwards compatibility.

SYNTAX:

HDATA(VarNum,offset/date, Optional future, Optional MarkViolation, Optional ViolationBoldFlag, OptionalViolationForeColor, Optional ViolationBackColor) 

VarNum:  The variable number to get the value for.

Offset/Date:If the field is numeric it is assumed to be the offset and is defined as the offset (number of slots for the variable type) from the start date of the report.  For example, if the start date is 1/1/2000 and the offset is 2 the value for the 2nd data slot will be returned.  I.E. for an hourly variable the value for the 1AM to 2AM slot will be returned.

MarkViolation:  Set to 1 to mark violations (based on variables limits) if they occur.   How they are marked depends on the next settings.   

ViolationBoldFlag:   Set to 1 to bold violations. 

ViolForeColor:   Sets the foreground color of cells that contain violations.  Number represents a RGB color code (0 to 16,777,215).   

ViolBackColor:  Sets the background color of cells that contain violations.


NOTES:

Function is obsolete and has been replaced by DDV.  It is still supported for backwards compatibility.

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...
Thank God! Someone with brains sepkas! Approved: 5/23/2011 6:36 AM
Created on 10/1/2010 12:53 PM.
Last Modified on 5/13/2011 3:52 PM.
Last Modified by Scott Dorner.
Article has been viewed 2736 times.
Rated 7 out of 10 based on 2 votes.
Print Article
Email Article