Relationship between Date table [Date] column and a DateTime type column not working

[dsj8wksnnckk]

Hi all,

as my subject says, all of the sudden I noticed that this relationship is not working anymore. E.g if I use calculations or data from a table that has a DateTime type of column connected to Date table [Date] column the visuals don't work.

I never noticed this issue before.
Any ideas?

[Idrissshatila]

Hello @dsj8wksnnckk ,

the data will show blank when you connect a date with date time when you try to use this date in a visualisation.

[jdbuchanan71 · Accepted solution]

Make sure that the DateTime column in the table that is linking to the Date table does not have times on the dates.  If they do, it will not be able to make the connection because the Date/Time on the date table only contains 12:00:00 AM:

You can convert the Date/Time to a date to make it work if this is the problem.

[MattiaFratello]

Hi @dsj8wksnnckk, can you share an example as well as the relationships?