4 Replies Latest reply: Aug 26, 2015 4:01 AM by jagan mohan rao appala RSS

    Need expression for 1 year data

    virendra chawra



      My requirement is given below:


      I have to show list of user , who have not logged in in the portal from 1 year from there last login .



      fields are Login_Date, User_ID,User_name



      please suggest .


      Load Login_Date,User_ID,User_name

      From (./Login.qvd)(qvd)

      where  Login_Date <= Today() and Login_Date >= Addyears(Today()-1)




      KIndly suggest how to do this equation.