Forum Discussion

dsj8wksnnckk's avatar
dsj8wksnnckk
Icon for Resolver I rankResolver I
1 year ago
Solved

Relationship 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 t...
  • jdbuchanan71's avatar
    1 year ago

    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.