Distinct Dates

[anuradhaa]

the events in my data set has happend in different times,

will take two days 2015/12/10 and 2015/12/09,

below are the events

2015/12/10 @ 10.00 P.M  event 1

2015/12/10 @ 11.30 P.M event 2

2015/12/09 @ 09.00 PM event 1

2015/12/09 @ 09.00 PM event2

when i load these dates using

Date (mydate, 'YYYY-MM-DD') in script and use that date in bar chart in x axsis it shows multiple records

i mean two dates 2015/12/10  and two days 2015/12/09.  How to get distict dates.

Thanks

[#2 · Accepted solution]

HI,

While loading use date(floor(mydate),'YYYY-MM-DD') . it should fix your issue.

Thanks,

Sampath.