NOTICE: This version of the NSF Unidata web site (archive.unidata.ucar.edu) is no longer being updated.
Current content can be found at unidata.ucar.edu.
To learn about what's going on, see About the Archive Site.
> Full Name: Joseph Spain > Email Address: address@hidden > Organization: ImpactWeather > Package Version: 3.0u2 > Operating System: Windows 7 Ultimate SP1 > Hardware: > Description of problem: > > Greetings: > > Is it possible to enter a date range in a formula? For example, if > one wants to determine the average values of a variable for each grid > point from Jun 1 to Jun 15 over 30 years, what is the correct procedure > and syntax? > > In Microsoft Excel, this can be accomplished by using the following formula... > > {=IF((MONTH(date_range)=6)*(DAY(date_range)>=1)*(DAY(date_range)<=15),AVERAGE(variable_range),"")} > > Does IDV have an equivalent solution? I searched through previous posts > and the Jython library, but I did not find a solution. > > Please advise. > > Thank you. Joseph, I don't think there is a straightforward way at this moment. I am assuming you are talking about the point data and the procedures I can think about is: loading the data first, then, creating some kind of the point display, and in the display controls, you can use the filter to select the date range and do some calculation from there. Yuan > > Ticket Details =================== Ticket ID: WKV-733577 Department: Support IDV Priority: Normal Status: Closed