undefined

[Gurukiran003]

why calendar visual MAQ Software is showing one day less. example if start date is 1-2-2020 to 3-2-2020 then while showing in visuals its showing 1-2-2020 to 2-2-2020

[MAQSupport]

Hello,

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:

1. 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.
2. 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 meet your requirements and revert back in case of any further issues

[v-eqin-msft · Accepted solution]

Hi @Gurukiran003 ,

Oh yes! Sorry I didn't notice this.

But as shown in the screenshot I provided, the endDate is always 1 day less than the actual date. Based on my test, it depends on the Time. 

For example as shown below, if enddate is 2021/2/3 12PM >12AM ,then 2021/2/3 will be included. 

but for datetime=2021/2/6 12 AM, then 2021/2/5 will be the actual enddate.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-eqin-msft]

Hi @Gurukiran003 ,

Sorry I'm not fully understand your issue...

I have built a data sample, and everything works fine on my side. My PBI version is 2.95.983.0 64-bit (July 2021) ,you may upgrade to this version and have a try again.

Could you please provide some screenshots to help us clarify your scenario?

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gurukiran003]

Hi Eyeln u can see the start day for A is monday-1,Feb,2021 and End Date is Wednesday-3,Feb,2021 but in Visual blue color is applied from 1,Feb,2021 to 2,Feb,2021 thats what i am trying to say.

[MAQSupport]

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

[amitchandak]

@MAQSupport , can you help on this