Expression to Select Certain Date Range

[#1]

Hi,

I have a large amount of data, of which I draw a variety of charts from. The data has a date range of several years; and for some of the charts I would like to just report on certain years/months. Is there an expression I can add to my charts that would filter on year/month? If Start Date = xx/xx/15 effectively.

Part of my data table looks something like this:

Name	Start Date	End Date
JOB123	5/06/2013	5/06/2013
JOB123	11/06/2015	11/06/2015

Kind regards,

Tristan

[sunny_talwar]

If I understand you well, you might be able to use a set analysis like this:

{<[Start Date] = {"$(='>=' & Date(YearStart(Today()), 'M/DD/YYYY'))"}>}

[sunny_talwar · Accepted solution]

See if this helps:

Best,

Sunny

[#4]

Thanks very much Sunny; that's done it!

Best,
Tristan

[sunny_talwar]

No problem Tristan‌

I am glad I was able to help.

Best,

Sunny