Distinct Dates

anuradhaa — Fri, 11 Dec 2015 06:31:03 GMT

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

Re: Distinct Dates

Fri, 11 Dec 2015 06:43:50 GMT

HI,

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

Thanks,

Sampath.