The Tableau DATEPARSE is one of the date functions that will convert any field (in general string) to the date field based on the date_format and date_string arguments. This article shows how to use this Tableau DATEPARSE function to convert a field to the DATE field and what the alternative approaches (pre-built) with examples. Generally, … Read more
The Tableau DATEADD is one of the date functions that will add a user-specified number of intervals to the given date based on the date_part (first) argument. For example, if you pass 5 as the second argument and the year as the first argument, the DATEADD function adds five years to the given date, i.e., … Read more
The Tableau ZN is one of the Number Functions that will return the original expression or values if the cell is not null; Otherwise, it returns Zero. In simple English, the ZN function replaces the NULL values with 0 and prints the Not NULL values as they are. Remember, this Tableau ZN function only works … Read more
Tableau provides various Date Functions such as Year, Month, Day, makedate, maketime, datediff, datepart, dateadd, datename, datetrunc, now, today, etc. In this article, we will show you how to use Tableau Date Functions with examples. To demonstrate these Tableau Date functions, we will use the data shown below. As you can see, there are 15 records in … Read more
