Same date showing multiple times

[JoseGarcia]

Hi there, 

I have multiples records for same date. 
I did look at previous posts. But have not been able to get a solution.

Dimension name: 

= date(DateReportDate)

Script: 

[date_of_report] AS DateReportDate,

can anyone assist?
As always, thanks a million!

[Chanty4u · Accepted solution]

Might be format issue.

can you try this in script  ?

Date(Floor(date_of_report)) as DateReportDate

or

Floor(date_of_report) as DateReportDate

or

date(date#(date_of_report,'DD/MM/YYYY'),'DD/MM/YYYY') as DateReportDate

[JoseGarcia]

thank you both! 
it worked! 

Regards

jose