Type conversion function that changes string and number expressions into dates, as long as they are in a recognisable format. The date functions on this page allow you to manipulate dates’ calculated fields, not set their display formatting.

See Custom Date Formats and related topics for working with date fields. You might need to format it rather than use a date function. Tip: Is your field already recognised as a date (it has a date icon in the Data pane) and are you trying to control how it appears in the viz? Use the ISO-8601 calendar: ISO-8601 Week-Based Calendar.Set default date properties: Date Properties for a Data Source.Format how a date is displayed in a viz: Custom Date Formats.There are several other topics that might be of interest but aren't part of date functions: These are covered in more detail at the end of this topic. Gain familiarity with other date conceptsĭate functions sometimes reference date-specific elements, including the date_part argument, the optional parameter and date literals (#). Using dates in calculations often requires the use of date-specific functions. When date fields are used in the viz they get a special set of functionality, including an automatic date hierarchy drill down, date-specific filter options and specialised date formatting options. If a field contains recognizable dates, it will have a date or datetime data type. Dates are a common element in many data sources.

Tableau calculated field subtract dates