AnsweredAssumed Answered

Undocumented functions in power filters/ expression builder?

Question asked by btumbleson on Jan 17, 2018
Latest reply on Jan 18, 2018 by Sarmistha_Purkayastha

Hey all,

 

Trying to build what should be a very simple function as a part of a workflow. Basically all I need to do is take a date field from a project and check if it's in the current year. 

 

My original thought was I could write something like:

 

RIGHT(Convert(ToString('project.thisProject.schedule_start')),4) == dateMacro("currentYear")

 

The idea being that I could take the schedule start date attribute (say 1/1/18), then convert it to a string (presuming it would get rendered at 01012018. Then take the 4 rightmost characters = 2018. Then compare that to the currentYear using the dateMacro.

 

Obviously this doesn't work, but I can't seem to find any sort of functions or documentation relating to functions for expressions. 

 

This should be easily accomplished without having to write a gel script. Any help?

Outcomes