Date filter for Time Entry Date

[Michael Gonzalez]

Hello, I am using the Tableau AIO connector and would like to add a filter to the connection like the one below but get a syntax error. What would be the correct syntax? 

Time Entry Date >= startOfMonth(-6)

[Petter Gonçalves]

Hello @Michael Gonzalez

Welcome to the Atlassian Community!

Per your JQL query, I understand that you would like to return the issues where the "Time Entry date" is 6 days before the start of the current month or after that date. Considering the current month, you want issues where the "Time Entry date" is filled with august 26th or any posterior date. Is that correct?

If it's not, can you please describe to us what issues you want to display on your JQL query?

Besides that, I can see the following errors in your JQL query:

1. Jira does not have a "Time Entry Date" field. Can you confirm if that's a date picker custom field? If it is, a custom field with multiple words must be added between quotes to be properly rendered in a JQL query:

   "Time Entry Date" >= startOfMonth(-6)

   
   If you are looking for the time that the issues were created, you should use the "created" field:
   

   Created >= startOfMonth(-6)

2. You are not configuring a unit for the startOfMonth variable (-6), so it is considering months, weeks, and days. Please, set it with the correct unit you need. E.g:
   If you want it to be considering days, this would be the query:

   "Time Entry Date" >= startOfMonth(-6d)

Let us know if you have any questions.