Only certain dates.

[bobbydave]

I have a calendar that goes back as far as 2010.

I only want to show from 2014 onwards.

if(date(date#(Calls.Date, 'DD/MM'YYYY'), 'YYYY') >= '2014', Calls.Date)

So I am converting Calls.Date to a year and if it is greater than 2014, keep this.

I know there has to be an easier way.

Is there?

[sunny_talwar · Accepted solution]

May be this:

If(Year(Date#(Calls.Date, 'DD/MM/YYYY')) >= 2014, Calls.Date)

[bobbydave]

Excellent.

Thanks.

[jonathandienst]

The date interpretation logic should be in your load script; as well as derived date fields. It will make expressions and sorting simpler to implement. So instead of

     LOAD

     ...

     Calls.Date,

Do this:

     LOAD

     ...

     date(date#(Calls.Date, 'DD/MM/YYYY')) As Calls.Date,

     Year(date(date#(Calls.Date, 'DD/MM/YYYY'))) As Calls.Year,

Now your front end expression is

     =If(Calls.Year >= 2014, Calls.Date)