Generate Attribute Quarter from Date

WhiteBeardWhiteBeard Member Posts: 2 image Learner I
Trying to create attribute to have Quarter from a date attribute. Getting Month number using  "date_get([Date Inserted],DATE_UNIT_MONTH,"GMT")+1"

but not able to convert or calculate Quarter. 

Thank you.

Best Answer

  • WhiteBeardWhiteBeard Member Posts: 2 image Learner I
    Solution Accepted
    Found the solution.
    str(floor((date_get([Date Attribute],DATE_UNIT_MONTH,"GMT")/3)+1))
Sign In or Register to comment.