DWO returns a date only when data occurs for the variable specified by VarNum.

SYNTAX:

DWO(VarNum,Offset, Format)

VarNum: The variable number to search to decide what day to display.
 
Offset: Sets whether to display the date of the 1st value (i.e. offset of 1), 2nd value (offset of 2), etc...

Format:  Date Format to display.  Common formats:

"mm/dd/yy" 01/01/96
"mmm" Jan
"mmm yyyy" Jan 1996

NOTES:

Use Locate, Daily Values to locate the DWO function into the report.  Check the Print data only when it occurs and the Place Date beside Data options on the options tab.

EXAMPLES:

Data for variable 41, Influent TSS is tracked on Monday, Wednesday,  and Friday.  When Print data only when it occurs is used, only Mondays, Wednesdays, and Fridays are shown:

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