How to select cases based on dates?
Article ID: KB0082573
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.7 and higher |
Description
This article shows how to specify case selection condition by dates. This can apply to any condition where you need to subset a dataset, analyze data or make a graph based on cases selected by dates.
Issue/Introduction
How to select cases based on dates?
Resolution
Statistica can select cases based on dates by enclosing the date with # symbols.
For example:
To select the week of January 18 through 24, 2009, for variable 6 in a spreadsheet, the case selection condition can be specified as: v6>=#1/18/2009# AND v6<=#1/24/2009#.
Time functions can also be used with this selection method, for example: v6 > #3/5/07 12:03AM#.
Our e-manual include help document regarding How are dates represented in STATISTICA data files? and Case Selection Conditions - Syntax Summary
Feedback
Yes
No
Powered by
