next date using firstValue or fiesrSortedValue

[#1]

hello.

i have some actions that suposed to hapen in the future.

i need to get the first date fron all the future dates if there are bigger than today.

for example i have the dates 25-03-2016, 13-8-2016, 6-9-2016

and i need to get only 25-03-2016 as next date.

this is the code that i have:

load AccountId,

  if(date(max(DriveDate_DateFormat))>Date(Now()),FirstSortedValue(date(max(DriveDate_DateFormat)),1)) as NextDonationDate,

  Resident DonationEvents

  Group By AccountId;

the error is " Nasted aggegation not allowed"

need your help please

[Kushal_Chawda]

what is the format of DriveDate_DateFormat?

[Gysbert_Wassenaar · Accepted solution]

Try this:

Load

     AccountId,

     Min(DriveDate_DateFormat) as NextDonationDate,

Resident

     DonationEvents

Where

     DriveDate_DateFormat > Today()

Group By

     AccountId

     ;

[#4]

date

dd/mm/yyyy