Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

MAQ Software Calendar Bug?

MAQSupport  I am using the Caendar visual to display downtime in our plant and this may be a possible bug, or perhaps a formatting issue I may be missing.   In the attached image it shows that the ...
zxf223's avatar
zxf223
New Member
4 years ago

The issue seems still existing with the newest version. Can MAQ fix it?

  • MAQSupport's avatar
    MAQSupport
    Solution Supplier
    4 years ago

    Hello,

     

    Thanks for reaching out.

     

    For formatting start and end date, you need to consider the following as these are unfortunately the limitation of the API used to render the Calendar visual:

    • When only date (not date time) is provided as End date to the visual, it takes the end time for the event as 12:00 am and hence, the event ends on the previous day. For example, when date is 29/1/2019, by default it takes 29/01/2019 12:00 AM as its end date time.
    • If an event lasts for more than a day and the start and end times are before 9 AM, then the end date of the event in the visual will be a day before the end date given in the data. Tooltip will represent the date and time as per the data passed.

    Let us know if it meets your requirements and revert back in case of any further issues

     

    Thanks

    MAQ Support

    • kstacy46's avatar
      kstacy46
      Regular Visitor
      4 months ago

      Hello! I am having the same issue with date/time correlations. I have my calendar connected to an excel spreadsheet. The spreadsheet has 4 separate colums: Start Date, End Date, Start Time, End Time.... but the events still end one day early, they never reach the correct end date. Most events have times from 9:00am - 5:00pm. I have the excel spreadsheet set up as drop down lists for the dates and times, so it would be very hectic to format these colums as mm:dd:yyyy hh:mm AM/PM. Is this the only solution?