I am trying to write a formula to list "Y" if Last Login date is <= 90 days from today's (current date) - see below:
IIF([Last Login])<=90"days"([2021-030-18]"Y","N")
What am I doing wrong?
Hi youll want to use the datediff fuction
if DateTimeDiff(DateTimeToday(),[date2],'days')<=90 then 'Y' else 'N' endif
Hi @Lkschwe
Try this. I'm using the 'datetimediff' function to determine the number of days between today and the last login date. This assumes your last login field's data type is set as a date. Hope this helps.
IIF(datetimediff(datetimetoday(),[Last Login],'days')<=90 , "Y" , "N" )