Date Time format issue

Hi Keith Esslemont,

Can you provide additional detail about the behavior you are experiencing, which screen you are experiencing it on, and how it differs from the behavior you expect?

In my experience, Report filters let you set an "Is Between" operator for Date and DateTime fields, which is how I would make a report that shows all the January or Feb events in the described context. I recognize that you describe an interface as stuck due to DateTime, and would like to better understand where the behavior is sticking for you.

Hi Patrick

Thanks for the reply. I think I have worked out the "date/Time format issue. However do you know how I could try and achieve the following report.

Sales Person 1   Target 1000    Actual Sales 900  Month January etc running total for the year

Sales Person 2   Target 2000   Actual Sales 450   Month January etc running total for the year

I would like to see a bar graph showing the Monthly Target next to the Actual.

My Sugar fields are in the Opportunities Module as Target, Actual Sales, and Sales Person.

Thanks

Hi Keith Esslemont 

You just need to create a Summation Report and select the datetime field as group by field.

Regards