It appears to be your MOD function causing the skip.
You will only get a date label when the date value is evenly divisable by 5 and no remainder. Looks like your yearly data doesn't enclude all possible dates. Notice the last quarter dates on yearly do match labels on the Quarterly chart.
I am not sure of the second part of the logic ...
GetNthRecord( Database::Date;Get(RecordNumber)-1) < Database::Date)
If you sort your found set chronilogically, then you will be FALSE if previous record is empty and if it is EQUAL dates.
I wouldn't think it is even necessary to have that logic, if sorted.
You will still skip a date if every day of the year is not in your yearly records.
The yearly data includes all the dates, check out what happened when I removed and (GetNthRecord( RB Rounds Database::Date;Get(RecordNumber)-1) < RB Rounds Database::Date).
Now I am just using If ((Mod ( RB Rounds Database::Date ; 5 ) = 0) ; RB Rounds Database::Date ; "" ) to generate the dates.
All the dates I want are showing up now but there are several dates stacked on top of eachother (this is why I added that logic). Also, it gets even weirder because now it's only showing up to 8/25 when my database goes up to 10/12. This is the same database as before so this doesn't make any sense...
Here is a look at the data of where the graph skips just to show my calculation should work with the unsorted data. In my opinion, it's a little silly that I've had to create a calculation to properly display the dates so I was hoping there was a better more acceptable way of showing dates like this.
Well I think you are using and Area Chart type and trying to chart the x-axis using an unsorted found set.
If that is true...
Then you are plotting multi point data on same date, thus multi label data.
What is your y-axis value on same date? Does it vary?
I assume this calculation is using the Calculation option on x-axis in the chart inspector.
Tell me more please.