10 Replies Latest reply: Jul 26, 2011 3:10 AM by Miguel Angel Baeyens de Arce RSS

    Formatting datefield which contains timestamp

      Hi All

       

      I am trying to load only the date from a field which contains date with time stamp. I tried the below code but it is not working as expected. Could you please help me out on this? I have attached the sample application with the qvd file where I am loading from.

       

       

      Login1:
      
      LOAD Date(Login,'DD/MM/YYYY') as Login
      FROM
      C:\Login1.qvd(qvd);
      

       

      Thanks

       

      Attitude