Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use rowno()
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.
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.
Date:
LOAD * INLINE [
DATE
01/10/2015
01/10/2014
05/10/2013
01/10/2014
01/10/2015
];
try Count(DATE)