Forum Discussion
How to not use Auto-date/time
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
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
3 Replies
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
Thanks, this is what I needed 😊
Thanks also amitchandak , I do know however the setting, only I want it not for all. Thanks again,
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
