Hello
Trying to have a query that its records warn when date [RegDay] of a person [athleteID] comes as 30 days or less to complete 1 year passed from then to Date() , and if so in the calculation field [RenewReg], indicate if minus 30days, the days left to complete one year, if passed year since [RegDay] to show "Missed Reg"
Tryied in the logic by mind
RenewReg: Iif(Datediff "d", Date()-[RegDay]<=30,"DueReg", "MissedReg")
But how in that logic if true show days left to complete one year (365) days??
Trying to have a query that its records warn when date [RegDay] of a person [athleteID] comes as 30 days or less to complete 1 year passed from then to Date() , and if so in the calculation field [RenewReg], indicate if minus 30days, the days left to complete one year, if passed year since [RegDay] to show "Missed Reg"
Tryied in the logic by mind
RenewReg: Iif(Datediff "d", Date()-[RegDay]<=30,"DueReg", "MissedReg")
But how in that logic if true show days left to complete one year (365) days??