need to limit via WIQLQueryBit on System.ClosedDate >= '01-02-2023' #1679
-
need to limit via WIQLQueryBit on System.ClosedDate >= '01-02-2023' this is my query for closed work item and it is failing: What do I need to do to just get the current years closed work items only migrated? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
The GMT txt in your date is defo invalid. Use https://learn.microsoft.com/en-us/azure/devops/boards/queries/wiql-syntax?view=azure-devops to get the format that you need. There is a WIQL Query editor plugin for Azure DevOps that lets you create a query in the UX and then copy the text. If you are not comfortable with query languages this will get you what you need. |
Beta Was this translation helpful? Give feedback.
The GMT txt in your date is defo invalid.
Use https://learn.microsoft.com/en-us/azure/devops/boards/queries/wiql-syntax?view=azure-devops to get the format that you need.
There is a WIQL Query editor plugin for Azure DevOps that lets you create a query in the UX and then copy the text. If you are not comfortable with query languages this will get you what you need.