topic Re: How to get data by default date but not max date in App Development

How to get data by default date but not max date

Anonymous — Thu, 07 Jun 2018 00:52:12 GMT

Hello, Friends!

My problem is to get the default date for data selection, but not the max date.

Usually, we can use Max("Date_Filed") to get the max date for today, also current year or month.

But I have a table which has some data in future. That means max date is not today. And I cannot get current year and month via this method.

for example

If I use Max("Date (YYYY-MM-DD)"), Then I get date 2018-09-01 which is in future.

What I want is to show data on today (2018-06-07) or to sum from 2018-01-01 to 2018-06-07 and so on.

And with another important point that if I change the date, the data shown is also changed.

If anyone met the situation before?

Thank you very much.

Anonymous — Thu, 07 Jun 2018 03:20:40 GMT

Get it done by If() + GetSelectedCount()

bramkn — Thu, 07 Jun 2018 05:52:37 GMT

if(GetSelectedCount(date)>0,max(date),today())?

Anonymous — Thu, 07 Jun 2018 06:25:54 GMT

if(GetSelectedCount(date)<0,today(),max(date))

bramkn — Fri, 08 Jun 2018 06:01:16 GMT

you can never select less than 0?

Anonymous — Fri, 08 Jun 2018 06:06:05 GMT

oh, yes, you are right.

sorry for that.

it is less than 1