How to not use Auto-date/time

[VoltesDev]

Hi,

With my setting to turn on "Auto date/time", as I understand this will automatically convert our date fields into having date hierarchy. Is there an option to turn off or display the original in some of the field ONLY ? 

Meaning I still want to use that feature for some date field, but there are time I may not need that for some display or some other date in my other table.

Thanks

[AllisonKennedy · Accepted solution]

@VoltesDev , on the visual where you want to display the date only, click the drop down arrow next to the Date Hierarchy and choose the 'date' option. 

However, I do recommend you create a dimdate table and use that custom hierarchy instead: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 

[VoltesDev]

@AllisonKennedy 

Thanks, this is what I needed 😊

Thanks also @amitchandak , I do know however the setting, only I want it not for all. Thanks again,

[amitchandak]

@VoltesDev , setting to turn off for all. In options and setting -> options -> Data load (Global/file level) -> Auto time intelligence off

Also when join date to a date of the date table, which is marked as a date table, you will not get the date hierarchy