How to apply database function

Adhoc
#1

Get quarter, month and day from travel_date variable ?

#2

Hi abhishekg,

I am assuming travel_date is a date datatype column.

Following are the steps to apply database function on a column :

  1. click on the selection
  2. “More” option will come and click on “More” option
  3. In more option, you can apply any of the database function
  4. The list of database function is displayed based on column datatype.
  5. Then, select the function ( in your case quarter, month, day can be selected )

To apply single database funtion, please refer to the link "Quick Database Function"
http://www.helicalinsight.com/adhoc-module/quick-database-functions/

  1. To apply nested function, refer to the link "Advanced Database Function"
    http://www.helicalinsight.com/adhoc-module/advanced-database-functions/

Thanks,
Helical Insight Team