Apex Code Development You need to sign in to do that
Don't have an account?
Susan Ross-Wentworth how do I create a report grouping using an event's date and time
Hi,
I’m trying to create report which will show a user whether they have double-booked any of their scheduled events. I created a report for each user and the events assigned to them, thinking I could then summarize the report by grouping together all events which have the same date and time. When I drag the “Time” field into my report as a column, it displays the date and time but when I use the Time field to create a grouping, the time portion gets dropped and only the date is applied, which means anything on the same day regardless of time get grouped together. I’ve tried grouping on the “Due Time” field as well but the same thing happens.
I also tried creating a custom field on the activity which would convert the “activitydatetime” field to text and then use that in my report but the custom field I created using TEXT(ActivityDateTime) always returns the incorrect event time.
I’m trying to create report which will show a user whether they have double-booked any of their scheduled events. I created a report for each user and the events assigned to them, thinking I could then summarize the report by grouping together all events which have the same date and time. When I drag the “Time” field into my report as a column, it displays the date and time but when I use the Time field to create a grouping, the time portion gets dropped and only the date is applied, which means anything on the same day regardless of time get grouped together. I’ve tried grouping on the “Due Time” field as well but the same thing happens.
I also tried creating a custom field on the activity which would convert the “activitydatetime” field to text and then use that in my report but the custom field I created using TEXT(ActivityDateTime) always returns the incorrect event time.