Beyond the functions discussed so far, there are some other important functions that are useful and available in Tableau. One of those is the type conversion functions. Type conversion functions are useful for converting one data type into another, for example, from an integer into a string or from a float into an integer.
All of the following functions follow the common syntax of Function(expression):
|
DATE |
It is used to obtain a date from numbers or strings or date expressions, for example, DATE("25/05/2019") returns #25-05-2019#. |
|
DATETIME |
Very similar to DATE, this function returns the date and time, for example, DATETIME("25 May 2019 13:40:00") returns #25-05-2019 13:40:00#. |
|
FLOAT |
This is used to cast to floating-point numbers, for example, FLOAT(2)=2.000. |
|
INT |
This is used to cast its argument to integers, for example... |
