Calendar /Script Oddity

Anonymous — Thu, 10 Dec 2015 21:13:04 GMT

Hello All,

All of a sudden I'm not returning data as expected in my salesforce application. The problem appears to be related to dates. Up until November of this year, my app matches salesforce reporting to the penny.

I'm using a standard calendar script (as found here: Creating A Master Calendar). If I choose a quarter from the opportunities table, I'm returning a different revenue number than if I choose the same quarter from my calendar table. Is there some format conversion that's taking place during the reload on the calendar? (Something may have happened in salesforce that is causing the days to come back as partial days because there are suddenly oddities in the data when looking at different formats, such as decimals. I'm having our salesforce admin look into that.)

Here are my examples with the script and selection.

When choosing the Close Quarter taken directly from the Opportunities table:

And when choosing the Close Quarter taken directly from the Calendar Table:

As you can see I'm using CloseDate as the driving date behind all date choices here. Why would one return different results than the other?

Re: Calendar /Script Oddity

MarcoWedel — Sat, 12 Dec 2015 21:30:39 GMT

‌please post sample application.

regards

Marco

topic Re: Calendar /Script Oddity in QlikView

Calendar /Script Oddity

Re: Calendar /Script Oddity