How to format timestamp when using Calendarauto

[ArT101]

I created a calendar table using the calendarauto function. Now I kept getting the dates all the way from 1899 which I knew was not within my dataset. I found a way of resolving the issue by changing the data type for the timestamps to text. This resolves the calendar auto issue but now I want to be able to drill my visuals down from, year, month, day and hour. With my timestamp being text it doesn't show me the visuals hourly. If I change the timestamp back to time it effects my calendar table. 

I'm trying to find out ways in which I can tackle this issue while still using the calendarauto function. I am aware of the calendar min/max function but I would rather prefer to use the calendar auto function. 

Much appreciated for your help. 

[Shaurya]

Hi @ArT101,

I'm curious as to why you are getting dates that lie outside the range in your dataset. Can you share some screenshots elaborate the same.

[ArT101]

So this is the calendar table after I have converted the timestamps within my data tables to text

 But once I revert the timestamps data type back to time this is what happens to my calendar

This was the youtube video I used to resolve the issue I had with the calendar before converting time to text: 

https://www.youtube.com/watch?v=lAIfeVf5k9E