Monthly Archives: November 2011

Tableau Dynamic Linked Parameters

2020-03-06T19:45:09+00:00November 26th, 2011|Tableau|

The first thing to tell you is this isn’t possible, one of the few weaknesses in Tableau. I wanted to set up two parameters in Tableau, a start date and an end date. What I wanted to do should be simple; to base the available end dates on the start date parameter selection. This means [...]

Quickest way to remove the time from a datetime in SQL

2020-03-19T14:37:35+00:00November 10th, 2011|SQL|

In an earlier post I showed some ways to remove the time portion from a date. The obvious follow on from that is which is fastest. To test I ran both versions on a dataset of 1.9m rows of data. The DATE datatype returned the records in 15m 35s = 935s Getting the data using [...]