Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to compare two date fields in the set expression.
I am using the following expression -
count({<date_1={"=(date_1>date_2)"}>}date_1)
But it is giving me output as 0.
Any help here will be much appreciated.
I made the format same for both the dates but still it is not work.
I am working on a dummy app to try this out.
I have just inline load date_1 and date_2 and applied this expression.
To be more precise i am trying this out on the following table
Table:
Load * Inline
[
date_1,date_2
31/12/2010,31/10/2010
12/01/2018,14,01/2018
13/01/2017,14/01/2018
15/06/2017,21/01/2016
12/01/2019,14/01/2018
];
I am getting this:
Appreciate your help.
Will try it out again.