Hi
I have a select list field which consist of a values yyyymm e.g 201308 or 201309.
Is it possible to have a JQL function which returns me the value yyyymm based on current date and then I can compare this returned value to the custom select list field in JQL search?
thanks in advance
I would suggest using a calculated field - https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+Fields
Be sure to select the Date Time Range picker as the searcher.
This field would populate from 201308 to August 1, 2013 (as a date)
You could then use JQL to do very powerful searches:
customfield > startOfDay()
customField < -3d
or even
ORDER BY customField
see https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Created for an example of date based searching.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.