Interval from one date the the other

[Anonymous]

Hi guys,

Just a simplie question relating to datediff.

I have a table with many dates per rows and want to compare these dates to 30/06/2020.

What I did so far was the following:

 - Age = datediff(30/06/2020,'Gross 16-18'[End CAP Account],YEAR)

What I want from it is the interval from the 'Gross 16-18'[End CAP Account] compared to 30/06/2020

Did I use the formula wrongly?

Thanks heaps,

Diego 

[amitchandak · Accepted solution]

@Anonymous ,

Try like

Age = datediff('Gross 16-18'[End CAP Account],date(2020,06,30),YEAR)

or

Age = datediff(date(2020,06,30)',Gross 16-18'[End CAP Account],YEAR)

[Anonymous]

Hi @Anonymous ,

You can try to change to parameter sort in the function:

Age = datediff('Gross 16-18'[End CAP Account].30/06/2020,YEAR)

Aiolos Zhao