Date Format for Quarter Not Working

[Sage Lesko]

I have a step in our automation to create a variable, the current quarter, that is used later in the automation. The smart value I have defined is {{now.format("Q")}}.

The issue is the smart value that is used later doesn't result in what I expect (i.e. Q3). What's more weird is this worked previously but for the past several quarters, the automation hasn't been working correctly. Bug or did the format template change for quarterly variables? I'm not finding anything in my searches to show why this wouldn't work. 

[Bill Sheboy]

Hi @Sage Lesko 

What is the type of your Quarter custom field?  It appears to be single-select option type.

If so, you probably need a complete value in the variable rather than trying to combine them when setting the custom field.  Thus, there are two things to try:

• Modify your rebateQuarter variable to add the Q as a prefix Q{{now.format("Q")}} and then use just {{rebateQuarter}} when setting the field
• If that does not work, you may need to use a JSON expression to set the value...after first identifying your custom field ID:

{
  "fields": {
    "customfield_12345": { 
      "value": "{{rebateQuarter}}" 
    }
  }
}

Kind regards,
Bill

[John Funk]

Hi Sage,

Maybe try a space between the Q and {{  - just to see.

Also, log out the value of the smart value to see if it is returning a value.