Looping for a particular datetime
Posted on 2008-10-22
I have a databases which stores dates for a particular process. The process can have many different elements i.e can be changed from one stage to another, pending, here, their, anywhere...
1 13/10/2008 10:06:31 13/10/2008 10:06:31
2 13/10/2008 10:06:31 13/10/2008 10:06:31
3 13/10/2008 10:09:45 13/10/2008 10:06:31
4 13/10/2008 10:46:08 13/10/2008 10:49:31
5 13/10/2008 10:51:19 13/10/2008 10:51:20
Here the stage date is what is of interest. I need to use crystal, a formula Im assuming to get the STAGEDATE which signifies a change. In this case it would be RowNum 4 albeit 5 is different Im only interested in 4. How can I use Crystal to look through each record to do it . Bear in mind their are 1000s of different processes. A typical process could be - PAYJOEBLOGGS which has several elements in its actual completion such as start, pending, waiting, departmentx etc. The table is called PROCESS and each unique processID has lots of different elements as I have depicted above, 1,2,3,4 & 5 all belong to process 123456. Im messing abotu with WHILEREADINGRECORD etc but I think a loop is needed.