Solved

Custom Property - Grouping of dates


Hey,

 

I have a couple of custom grouping properties, stuff like:

if("Facebook" in A or "Linkedin" in A or "Twitter" in A, "Social", A)

 

I was wondering if its possible to do this with dates. Trying to create a custom property that splits:

  • All dates from May 1st till May 31st - Yes
  • All dates that are not this - No

Can i do this?

icon

Best answer by moinakb 19 May 2020, 20:23

hey @sanderoc, we unfortunately don’t support a lot of Date operators with Custom Properties at the moment (other than DATEDIF, that calculates the number of days/months/years etc between two date properties), but for this specific question that you stated earlier, you can cast the Date property into a string and then do a check if “2020-05” shows up in that stringified version of the Date property, something like this:

 

 

We will add this to our backlog, and thank you for reaching out.

Moinak

 

View original

2 replies

Userlevel 2
Badge +1

hey @sanderoc, we unfortunately don’t support a lot of Date operators with Custom Properties at the moment (other than DATEDIF, that calculates the number of days/months/years etc between two date properties), but for this specific question that you stated earlier, you can cast the Date property into a string and then do a check if “2020-05” shows up in that stringified version of the Date property, something like this:

 

 

We will add this to our backlog, and thank you for reaching out.

Moinak

 

That helped! thanks!

Reply