Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 295 subscribers
  • Views 1164 views
  • Users 0 members are here
Related content from around SugarClub

Date Time format issue

Keith Esslemont

Hi All

We use a field in Sugar to record our Race Dates and the format is date - time (See below). My question is how can I get a report that shows all the January or Feb event etc. I seem to be stuck due to the date-time format. Is there away of adding up all the dates for a month and reporting them as one amount? 

SugarCRM Enterprise, Version 8.0.2 (Build 255) (Spring '18)

Parents
  • 0

    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

Reply
  • 0

    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

Children