2 Replies Latest reply on Jul 20, 2012 3:50 PM by Blair Gibb

Date Filter shows times on Server

Blair Gibb Jul 12, 2012 1:37 PM

Hi All,

I have a date filter set up to show a range of dates. It is based on a calculated field that truncates a date field:

DATETRUNC('day',[SessionDate])

The filter works fine. In the development tool, it shows just the date without the times. When I publish it to the server, just the dates show up at first, but as soon as the filter is touched, the times show up. This occurs even when the 'Show times' checkbox is unchecked.

Is this a problem with DATETRUNC, or with the filter in general?

1. Re: Date Filter shows times on Server

Blair Gibb Jul 12, 2012 2:20 PM (in response to Blair Gibb)

A Quick Filter with this calculated field works correctly:

DATE(STR(DATEPART('month',[SessionDate])) + "/" + STR(DATEPART('day',[SessionDate])) + "/" + STR(DATEPART('year',[SessionDate])))

The DATETRUNC function retained the time (of 12:00 AM) after the truncation.
Like Show 0 Likes(0)

Actions
2. Re: Date Filter shows times on Server

Blair Gibb Jul 20, 2012 3:50 PM (in response to Blair Gibb)

This worked on the development server, but not on the production server.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Date Filter shows times on Server

1. Re: Date Filter shows times on Server

2. Re: Date Filter shows times on Server

Actions

More Like This