Home : MVUDWO
Q14308 - INFO: MVUDWO
 MVUDWO returns the Xth Unique Date (where X is set by Offset) from a series of values.

SYNTAX:

MVUDWO(Offset, DateFormat, VarNum1, VarNum2, ...,VarNum99)
MVUDWO(Offset, DateFormat, "Where Clause")
where :
Offset sets which date to return, (i.e., 1st date, 2nd date, etc...)
DateFormat is the Format for the date to return. Common Formats:

"mm/dd/yyyy" Returns: 08/15/2008
"mm/dd/yy HH:MM" Returns: 08/15/2008 10:45

VarNum1, VarNum2,...,VarNum99 is a comma separated list of variables that sets which variable to search.
"Where clause" : Instead of providing a list of variables, you can use an SQL Where clause against the VarDesc table to get the list of variables. (i.e., "Units = 'mg/L'" would return all variables with Units set to mg/L. See examples.

NOTES:

All variables listed MUST have the same frequency (i.e., daily, hourly, ...).

EXAMPLES:

Input Data:  Data for these variables occurs on the 2nd, 3rd, 6th, 8th, and 9th.

Example Functions and their results:

=MVUDWO(1,"mm/dd/yyyy",9001,9011,9021,9031,9041,9051,9061)

=MVUDWO(1,"mm/dd/yyyy","VARNUM > 9000 AND NAME LIKE '%CHLORINE'")


SEE ALSO: MVVNWO, MVDWO ,DWO, V, VT

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 2/11/2015 3:54 PM.
Last Modified on 2/11/2015 4:23 PM.
Last Modified by Scott Dorner.
Article has been viewed 1571 times.
Rated 1 out of 10 based on 1 vote.
Print Article
Email Article