Count date

[#1]

I have Date column named newdate.

I want to create a new table which has two columns. a date column and count column which shows the count of each date.

For example 02/05/2016 will have count 1.

[Chanty4u]

use rowno() 

[Gysbert_Wassenaar]

If you see a 'date' value twice then there are two different values. Your 'date' is most likely a timestamp formatted as a date. So you don't see the time parts of the timestamp that do differ.

[jonathandienst · Accepted solution]

Change the load the table containing the date to:

     LOAD ...

          Date(Floor(newdate)) As newdate,

          Time(Frac(newdate)) As newtime,  // if you need the time part

          ...

This will prevent the timestamp problem explained by Gysbert.

[Anonymous]

Date:

LOAD * INLINE [

    DATE

    01/10/2015

    01/10/2014

    05/10/2013

    01/10/2014

    01/10/2015

];

try  Count(DATE)