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?

Where exactly is the problem in your screen shot? Can you post it again with a circle or something to highlight the problem area?

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.

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

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)


When I copy it across to another solution the grey dates display incorrectly for the same selected dates.


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

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

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)


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.

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