Options

Generate Attribute Quarter from Date

WhiteBeardWhiteBeard Member Posts: 2 Newbie
in Help
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.
Tagged:

Best Answer

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