Need to group by Date THEN Time

[raistlinmajere]

Hi,

I have searched to find a way to group by Date ('MM/DD/YY') then by time ('HH:MM'), but couldn't find anything. How does the Group By Expert Work in this case? I have the following in my Group By Expert...

GroupName (year({CALENDAR.DUEDATE}), "daily")

But it states that it requires a field.

Thanks
raist

[raistlinmajere]

bump

[ezzy85]

Go to group expert, select the date field and click the arrow, then select the time field and click the arrow. It should do it automatically. If you just want to sort it by date then time, you can just use the Record Sort expert.

[Aspnot]

If your datae and time are in the same field, then you can create Formulas for the DueDate and DueTime and then group by those formula fields.