HI Experts,
I have been battling with this date issue for far to long now and need some assistance. I am trying to compare two dates (date in SQL table with
Istoday()
and depending on the result, get that items ID. The code I currently have now works, but is giving me a delegation warning.
Set(SessionID,LookUp(tblTimeSheet_Data,ANumber = varCurrentUser && IsToday(StartDayDate),Id));

The delegation warning comes from the
istoday
part of the formula. I have tried other ways, but I am just not getting it right.
I also tried the below formula, but this one is not returning anything.
Set(Comparedate,DateAdd( Today(),1,TimeUnit.Days));
Set(SessionID,LookUp(tblTimeSheet_Data,ANumber = varCurrentUser && StartDay < Comparedate,Id));