Relationship with date table is not updating

[Anonymous]

Hello,

Situation:

Source of data: SQL server

Base table linked to a date table:Relationship date table

Visual with the data

And when I insert more records into the table for a greater period then the newly added records are (Blank)?

(most left bar)

Result after I inserted more data

How come the relationship is not updated? Am I missing something?

[RobbeVL]

If the relationship is working for the original data, it should work for new data.
Might there be any changes in the datatype of Date? a different format?

I also noticed that some of your origial data increased by adding new data. So something at your end might have changed.

[Anonymous · Accepted solution]

I feel really stupid.

The range of my CALENDAR(DATE(YYYY,MM,DD); DATE(YYYY,MM,DD)) was too small.

It started in April... :rolleyes: