Avoid duplicates in date field

[vkal12]

Hello Community,

I have a date field that contains a lot of duplicates for some dates. If I want to calculate the Sum of my field "Amount" I get multiple records with the calculated value for the same timestamp. 

At the end I would like to have one result for Sum(Amount) for each date. 

How can I get this to work? I am stuck at the moment... 

Thank you very much in advance!

I

[Or · Accepted solution]

Is this actually a date field? Odds are it's a Datetime field that has been formatted to only show the date portion. Applying DayName(Field) or Date(Floor(Field)) to the field should trim off any time parts.

[vkal12]

Hi Or,

thank you very much for your quick support. Date(Floor(Field)) solved my problem!