How to get the current date as a filter

[MatthewB9421455]

Hi ,

I’m trying to create a report for a dashboard that will show tasks that are within 3 days of the planned end date.

ideally I was looking for a filter such as current date is less than 4 days from planned end date.

i don’t know how to get the current date as an option- and also need it dynamic so tasks tick through as they become within 3 days of their end date. Whats the best way for me to achieve this ?

[AndersBGS · Accepted solution]

Hi @MatthewB9421455 

@you can utilize the relative operator such as planned end date is relative before 3 days ahead.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS · Accepted solution]

Hi @MatthewB9421455 

@you can utilize the relative operator such as planned end date is relative before 3 days ahead.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Vishwa Pandya19 · Accepted solution]

Hi Matthew,

Below filter should help you achieve your requirement.

If my answer has helped you in any way please mark it as correct.