Group a timestamp by day

[jgoddard]

Hi,

 

I'm running into an issue when I try to group my timestamp by day.  I have a Field: $F{testresult_tetstdate} Field class: (java.sql.timestamp) which I need to break into groups per day.  Currently, When I group it by this field, it groups on every individua; timestamp.  I've tried using .getdate, and i notice it returns the day, but still groups by timestamp....

The version I'm using is 5.0

So instead of 3 groups, the following selection of timestamps would create just 2 (Aug 26 and 27)

 

Aug 26 2013 17:00:00

Aug 26 2013 17:02:00

Aug 27 2013 14:22:00

 

This seems like an easy thing to do- in Crystal you could just select “by day”.  However, I’ve searched online pretty thoroughly, and can’t find a simple solution- is this just very complicated, or is there a way to do it?  Thanks in advance.

 

 

Thanks in advance!

 

 

[tusar.ranjan.pradhan]

hi,

you try one thing,  just separate dates into two columns (means one is timestamp and another one is date without time).

for grouping use date column and for view purpose show timestamp.

 

i hope it will work for you.......!