hello sir thank you for this script while trying it i got this error then i changed
this line
set #DailyReward, = gettime(DT_YYYYMMDD);
to
set #DailyReward,gettime(DT_YYYYMMDD);
then its working but the problem now is the remaining time to the next reward was not showing