YEARQTR(A)

Article summary

Did you find this summary helpful?

Thank you for your feedback

Date Transform: YEARQTR(A)

Use this function to:

Example Return Value:  20211,20191,20203

Parameter	JSON	Description
Table	“targetTable”: “MyTableName”	The target table on which the new field will be created
Filter	“dataset”: {DataSet_JSON}	Optional. If a filter is applied, records not in the filter Recordset will be returned as null.
Date Function	“p1”: “YEARQTR(A)”	YEARQTR(A)
A	“p2”: “DateTimeFieldName” “p2”: “DateFieldName” “p2”: “#YYYY-MM-DD HH:MM:SS” “p2”: “#YYYY-MM-DD”	Required. The date from which to extract the year and the quarter Supports: DataType: Discrete / Continuous Field Type: Date, DateTime Fixed Value: #YYYY-MM-DD, e.g. #2021-04-05 Fixed Value: #YYYY-MM-DD HH:MM:SS, e.g. #2021-04-05 11:01:08

{Insert Notes Here}

Example	Details
Description	Segment transaction data into yearly quarters
Input	Table: = [transactions] Function: = DateTransform DateTimeFunction: = YEARQTR(A) A:= [transactions].[date] Name: =YearQuarter
Sample

Was this article helpful?

Table of contents