Azure DevOps queries with date

0
votes

When I've creating queries, I have option for to compare date fields with macros, like 'Created Date >= @StartOfDay('-1d')'.
But all the macros that I found there works considering consecutive days.
I want something that do not consider the weekends and holidays.
Is there something like '@WorkDays("-1d")'.

1
azure-devops
How about the issue? Does the answer below resolved your question, If yes, you you could Accept it as an Answer , so it could help other community members who get the same issues and we could archive this thread, thanks. - Leo Liu-MSFT

1 Answers

0
votes

Azure DevOps queries with date

Agree with Krzysztof.

There is no such feature to exclude the weekends and holidays now. According to the document Operators and macros supported for each data type:

enter image description here

Azure devops only @StartOfDay, @StartOfWeek, @StartOfMonth, and @StartOfYear macros supported on Azure DevOps 2019 Update 1 and later versions.

There is no option to exclude weekends and holidays.

Besides, there is a user voice about it:

Add option to exclude weekends when setting up Styling rules using the 'Changed Date' field rule criteria

You could vote and add your comments for this feedback.

Hope this helps.