Date Conversion - Calculated Attribute | Community
Skip to main content

Date Conversion - Calculated Attribute

  • August 12, 2023
  • 2 replies
  • 0 views

Todd15

Hi,

We have a Tag on each Agent User record w/their Hire Date.  Our goal is to be able to report on agent efficiency based on their tenure (30/60/90 days).  The tag is formatted as "hire-07/01/2023".

But Explore isn't liking my Calculated Attribute Date field...

First step - get tag and parse out date

Then I want to use that Calculated Attribute to determine their tenure in 30-day increment brackets but I keep getting an error when trying to run the report:

The error is:

Thank you in advance.

 

2 replies

Todd15
  • Author
  • August 12, 2023

Sorry, here is my other attribute that captures the Tag


Dane13
  • November 30, 2023
Hi Todd,

Instead of tags, it will be better if you create a custom date user field and use that as your attribute. In addition, you can also use the [Requester Created - Date] attribute for your date based on Explore recipe: Tracking length of service of your agents.