past the date

[soniasweety]

Hi all,

Tresesco B

I want to display the details

where the completedate is past from now()

means : 

is anything need to change in exP?

[tresesco]

Second parameter of interval is a format. Try like:

aggr( Interval(CompletionDate-now(),'dd:hh:mm:ss'),numb)

[soniasweety]

here

       it past the now()  then display the number values

completedate

2017-08-01 03:59:59

2017-09-22 15:45:19

2017-09-22 15:46:29

2017-09-22 15:56:30

2017-08-02 18:29:59

2017-08-02 18:29:59

2017-08-02 18:29:59

2017-08-02 18:29:59

2017-08-02 18:29:59

2017-08-02 18:29:59

2017-09-05 18:38:00

2017-09-05 18:39:39

[tresesco]

if one numb has one date , try like:

=if(CompletionDate-today()>0,numb)

Note: Now() is performance killing, don't use it unless you really need it. If you are looking for current date, use today().

[soniasweety]

thanks.  its working    but I need to check its now()/CurrentDate

thanks for suggestions towards performance.