Need to group by Date THEN Time
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
Re: Need to group by Date THEN Time
Re: Need to group by Date THEN Time
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.
Re: Need to group by Date THEN Time
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.