shdawson
Active Member
- Joined
- Jan 6, 2007
- Messages
- 381
Hi,
What function would be the best to use for evaluating a range of rows and pick the MAX date from a particular column? In other words, the newest date?
Have some data that has 3 columns:
project id
report date
status indicator.
...with LOTS of rows.
This is output from a repository where people input the status of a task. That status changes now and again. The output I have contains all of the rows (entries) into this repository, by project id.
Need to look at the project date, figure out the newest date, then grab the status id.
Thanks...
What function would be the best to use for evaluating a range of rows and pick the MAX date from a particular column? In other words, the newest date?
Have some data that has 3 columns:
project id
report date
status indicator.
...with LOTS of rows.
This is output from a repository where people input the status of a task. That status changes now and again. The output I have contains all of the rows (entries) into this repository, by project id.
Need to look at the project date, figure out the newest date, then grab the status id.
Thanks...