Relation between two date fields

[Ganymed]

Can this be done? Tried to create a relationship it did not work? Can anyone help?
Thanks

[Jeff_Hager]

It won’t work if the underlying times are different…even by a few milliseconds. The underlying values have to match exactly, regardless of any visual formatting you may have on the date column.

Something along the lines of creating a math column to create a stable date value will work out much better when using it for relations.

How to sum values based on date (daily ,weekly, monthly)

I don’t see a Date column in your table? But, a general approach to summarise data by date is as follows: Use a math column to convert the date to an integer in yyyymmdd format: Year(Date)*10^4 +Month(Date)*10^2 +Day(Date) Create a multiple relation column that matches the math column with itself. Use a Rollup->Sum via the relation to sum the value/s that you’re interested in.