How to format a Date Value before using (testing) it?

Question

I'm writing a JQL to check the Due Week of the issues created, and I'm using a date field called "Deployment Date".

{{"Deployment Date".format ("w")}} gives me the value I need, but that only works when Smart Values and formats can be used. When I try to do a lookup and get all the other issues and their Deployment Date week so I can compare with the week of Deployment Date of a new task, the JQL breaks because it expects only operators... It's not clear if there's absolutely no way to format values before using them when searching.

How can I format a value during/before the comparison? What's the correct syntax so that I can use values/date values in the format I need them to be?

Thanks!

mateus.oliveira · Answer

This is what I have so far.

But, based on what you mentioned, I'll probably have to use a different automation to format the value I need to compare and save the formatted value on a different field... THEN use the Lookup Issues to check this field and compare to the formatted smart values from the triggerIssue...

Thanks!

Trudy P Claspill · Answer

Hello @mateus.oliveira

Is this in the context of an Automation Rule? If so, please show us the entire automation rule.

Regardless I believe that the answer is you can't apply the format command to a date field within a JQL statement. You will have to do the comparison outside of the JQL statement.