CCCDomo Member

Comments

  • Thanks MarkSnodgrass! I go the first two working including the last date of access filtered and the date format changed. To get the number of days last access I made minor changes to the code you provided as below and it is working too. DATEDIFF(CURRENT_DATE(),MAX(`DayAccessed`))
  • Thanks for your super quick reply RACERX! I am getting the following error when I try to add the filed using DATEDIFF(CURRENT_DATE - `DayAccessed`) although the Best mode validate without any problem. "An issue has occurred during processing. We are unable to complete the request at this time." I do not think it is…