Currently, there is no way to show only the date. This would be a good one to put in the Ideas section of the Community, as I just had someone yesterday request something similar.
Does anyone know if this has been changed in the 2014 release?
I am looking to just show the date and not the time.
I almost didn't reply because this thread is 3 yrs old, but why not use DATEPART to construct your own date format ?
2 of 2 people found this helpful
I believe the answer is that the <Data Update Time> is not specific to any worksheets or calculation, it is specific to a data source and its a handy little feature that can be used in Titles without having to worry about the data itself -- so, <Data Update Time> can be easily used in titles without having any date/time fields in the worksheet. Using a calculated field would require the field to be included on each and every sheet, which may or may not be feasible, depending on a number of factors.
I also had the same question, however i hit a dead end as there is no way get rid of the time part when we use <Data Update Time>.
One way was that you can place a blank text object on the dashboard. Change the background color of the text box to match the color.
Also, I got stuck into another issue is that the date format changes when view in browser or email (as an embedded image)
It would be nice if we could use the <Data Update Time> in a calculated field. Here's an example of two calculated fields I'd like to create.
DATEDIFF("second",[Data Update Time],NOW())
IF LEN(STR(INT([Seconds]%86400/3600))) = 1
THEN "0" + STR(INT([Seconds]%86400/3600))
+ ":" +
IF INT([Seconds]%3600/60) < 10
END + STR(INT([Seconds]%3600/60))
+ ":" +
IF INT([Seconds] %3600 %60) < 10
END + STR(INT([Seconds] %3600 %60))
I know this is an old thread but there have been some recent activity in it so there seems to be interest in the functionality. Go vote for this feature in the Ideas Forum at https://community.tableau.com/ideas/2471.
I used this method but encountered problems with Internet Explorer and Chrome. The rendering works differently for the two browsers.
So: if your audience is limited to using only one browser then it's fine. If they are free to choose a browser, then you might come across the same issue.
The only workaround I have found to this issue is to open a new sheet. and create a blank calculated field, (literally ""). Drop that on the text shelf, and float the resulting blank sheet to cover the time part of the date time. Hide the title, remove the borders and match the background color to match. It's not very elegant but it works.
I've shaded the sheet in the example below so you can see what's going on. Hope this helps!