Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Load
AccountId,
Min(DriveDate_DateFormat) as NextDonationDate,
Resident
DonationEvents
Where
DriveDate_DateFormat > Today()
Group By
AccountId
;
what is the format of DriveDate_DateFormat?
Try this:
Load
AccountId,
Min(DriveDate_DateFormat) as NextDonationDate,
Resident
DonationEvents
Where
DriveDate_DateFormat > Today()
Group By
AccountId
;
date
dd/mm/yyyy