time range

[3dthies]

I have the a fiel with following datas:

{Application.Timestamp} {Application.Data}
01.01.02 15:00:00 123123213
.... ....
.... ....

01.01.02 15:15:00 frgtdgdsg
.. ..
.. ..
.. ..

01.01.02 15:30:00 sdgddggsdgd
.. ..

01.01.02 15:45:00 ftrdtdstd
.. ..

...and so on

i want to display al datas from timestamp every half hour. How can I do this?

Thanks

Thies
..

 

[synapsevampire]

What is the output supposed to look like?

You can group on something like this, and place you fields in the details:

If Minute({datefield}) < 30 then Time(Hour({datefield}),00,00)
else Time(Hour({datefield}),30,00);

-k

 

[3dthies]

The output should look like this:

Time Data
08:00 - 08:30
08:30 - 09:00
..
..
and so on

 

[3dthies]

The problem of your formula is that i only get timestamps with minutes 15 and 45.

What i need is to summerize two timestamps (00 and 15) and the other two timestamps (30 and 45) as a half hour view.

 

[SmpTraining]

You say you want:

Time Data
08:00 - 08:30
08:30 - 09:00
etc.

but what should happen if there's no data for 08:30 - 09:00? Do you only need to see the times where data exists?

Steve Phillips, Crystal Consultant