Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this:
If(Year(Date#(Calls.Date, 'DD/MM/YYYY')) >= 2014, Calls.Date)
May be this:
If(Year(Date#(Calls.Date, 'DD/MM/YYYY')) >= 2014, Calls.Date)
Excellent.
Thanks.
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)