Page 1 of 1

greyed dates showing incorrectly

PostPosted: Thu Oct 24, 2013 9:32 am
by DogTheDBDeveloper
See attachment picture. It seems like there are grey dates displaying that don't match their actual month. They seem to be wrapping around to the same year for some reason (look at November and December of same year).

Is this a bug or something I can reset?

Re: greyed dates showing incorrectly

PostPosted: Thu Oct 24, 2013 6:24 pm
by jeffalmquist
Where exactly is the problem in your screen shot? Can you post it again with a circle or something to highlight the problem area?

Re: greyed dates showing incorrectly

PostPosted: Fri Oct 25, 2013 4:34 am
by DogTheDBDeveloper
Yes look at Feb and March of that screenshot - there are previous months days listed in light blue that aren't actually there. Notice that those dates are also blue in November and December.

This appears to be a bug. Those light blue dates in Feb & March are not supposed to be there.

Re: greyed dates showing incorrectly

PostPosted: Fri Oct 25, 2013 7:42 am
by JasonYoung
Hi,

I can't reproduce this in the stock copy, so I'm not sure what's tripping the conditional formatting in the March and Feb squares, but I do see what you're talking about. I'd be happy to take a quick look at the file if you want to send it over to [email protected]. Be sure to include the log-in info.

Thanks,
-Jason

Re: greyed dates showing incorrectly

PostPosted: Mon Aug 25, 2014 8:34 pm
by IanRenwick
Same problem (FM Pro Advanced 13 on a Mac). This is how the original displays (Note: I have the global basedate and SelectedList dates displaying as well)
screenshot_92.jpg
screenshot_92.jpg (219.98 KiB) Viewed 23988 times


When I copy it across to another solution the grey dates display incorrectly for the same selected dates.
screenshot_94.jpg
screenshot_94.jpg (202.81 KiB) Viewed 23988 times


The only difference is the way the global $$__NinjaCalSelectedList is displaying the date. Would not have thought this was the issue given that conditional formatting uses the Date function.

It does a similar thing when I select a single date where the Day ends in 1,2,3 etc

Re: greyed dates showing incorrectly

PostPosted: Tue Aug 26, 2014 7:19 am
by jeffalmquist
Hi Ian. I think this is just a date-format issue (U.S. vs U.K./Aus). Try cloning the NinjaCal file, then open the cloned file and copy/paste what you need from it into your file again. Let me know if that makes a difference. -Jeff

Re: greyed dates showing incorrectly

PostPosted: Tue Aug 26, 2014 3:11 pm
by IanRenwick
Hi Jeff. Saved the NinjaCal file as a Cloned copy. Opened it up and selected some dates and the original problem is replicated (refer to first pic).

When I changed the Conditional formatting calc for the "selected date, not in base month" from
PatternCount ( $$__NinjaCalSelectedList ; Self ) and ( Self < firstDateOfCurMo or Self > lastDateOfCurMo )
to
FilterValue ( $$__NinjaCalSelectedList ; Self ) and ( Self < firstDateOfCurMo or Self > lastDateOfCurMo )
it seems to work with the 1st & 2nd also displaying correctly, at least in my limited testing of it...probably need to test it out on a 12 month calendar to be sure. (refer the 2nd pic)
screenshot_98.jpg
screenshot_98.jpg (207.97 KiB) Viewed 23963 times


So I think the problem was if the numbers 11, 12, 13, 14, 15 ... or 21, 22,23 etc were selected the PatternCount was matching on the second digit 1,2,3,4,5,6,7. So FilterValue forces it to consider the 'whole' date value.

Re: greyed dates showing incorrectly

PostPosted: Tue Aug 26, 2014 3:22 pm
by jeffalmquist
That makes perfect sense. Nice work! I'll be sure to direct anyone else who encounters this problem to this forum post, and give credit to you. Thanks for figuring it out and sharing your findings. -Jeff