Forum Discussion
Resolver IRelationship between Date table [Date] column and a DateTime type column not working
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?
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.
3 Replies
- MattiaFratello
Super User
Hi dsj8wksnnckk, can you share an example as well as the relationships?
- jdbuchanan71
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.
- 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.
