Mark as date table (bogus error?)

[DoctorYSG]

I have tripled checked the "day" column in this table. Each value is unique and there are no gaps (I do this with external ETL tools in Planatir Foundry where I generate the table).

But I am still getting the following error aobut only one timestamp and no gaps. What is wrong. (The original times were in Zulu UTC, so that is why they show as 8:00 PM, but I can fix that if needed).


day table

[DoctorYSG]

That works. The reason that I did it with a timestamp is that I will want the table to soon change to hour/day/month/year. I did not see if it is possible to still flag this as a date table, and also how to organize this so that one can drill-down timecharts. 

The training classes I saw all used timestamps with the start of (day, week, month. But the date hierachies are really messy if one has a timestamp.

[FreemanZ · Accepted solution]

change the day column to date type, instead of datetime.