Nicci - Do you mean you want to evaluate a date/time value for each record, and based on the interval classify/'bucket' the record with a category value for each interval?

If, so this is a new formula field you can add in the Field Organiser block that 'buckets' each record, as exemplified here:

http://www.visokio.com/kb/useful-formulae

29-Apr-2013 00:00:00
30-Apr-2013 00:00:00
03-May-2013 00:00:00
03-May-2013 00:00:0

In this example,I want to merge the similar dates together and all the results associated to it.. like we do in pivot when we group the date its that logic I need at this stage. I tried to use the pivot block, but it doesn't pick that logic and was wondering, if some other block/formula can be used.

As long as you are careful to standardise the formatting in the whole field, this should be an Aggregation block

Thanks!