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

    Need expression for 1 year data

    virendra chawra

      Hi,

       

      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)

      NotExist(User_ID);

       

       

      KIndly suggest how to do this equation.