How to calculate min date of a list but higher than today?

[mrichman]

Hi Community,

I need to create a 'Days left' object. We have a list of deadlines and would like to show the difference between the min date of the list and today. However min date of the list should always be greater than today, so in this case 2018-05-29 instead of 2018-05-26.

Today is: 2018-05-27.

Example table:

LOAD * INLINE [

    Date1

    2018-05-26

    2018-05-29

    2018-06-29

];

Ideal result should be 2018-05-29 - 2018-05-27 = 2 days left.

Thanks in advance!!

[sunny_talwar · Accepted solution]

May be this

Min({<Date1 = {"$(='>=' & Date(Today(), 'YYYY-MM-DD'))"}>} Date1) - Today()

[mrichman]

Thanks!