Date and Time Functions

To use a date and time functions, follow these steps.

1. When creating or editing a visual, determine for which field variable you must adjust date or time presentation.

   The shelves that support date and time functions depend on the visual type, and are typically available for X and Y axes, Measures, Dimensions, Colors, and Tooltips.

2. Click the icon to the right of the variable.

   

3. In the dropdown, click Date/Time Functions.

4. From the Date/Time Functions menu, select one of the following options:

   • Date returns the value of to_date([field]).
   • Year returns the value of year([field]).
   • Month returns the value of month([field]).

   • Year and Month Count returns the value of the following expression:

     concat(cast(year([field]) as string), '-', if(month([field]) < 10, '0', ''), cast(month([field]) as string)) as 'month of year'

   • Day of Month returns the value of dayofmonth([field]).
   • Day of Year returns the value of dayofyear([field]).
   • Day of Week returns the value of dayofweek([field]).
   • Remove Function removes all of the above.

   

5. Click Refresh Visual.