5 Replies Latest reply: Nov 28, 2016 2:14 PM by Manish Kachhia RSS

    DateFormat Error

    Pranu bitla

      Dear experts,

      we have list of users. want to show any user DOB entered as incorrectly want to mark them as error in Qlikview. I am taking data from excel spreadsheets loaded in to QV, would you please suggest something. see below sample data column 4& 5 error data.

          

      ID DOB USER
      113/02/1949Sara
      216/12/1951Jeswanth
      307/04/1946Stephen
      4TempLinale
      51O2Ram
      612/05/1962Philip
      721/07/1958David
      801/05/1963merry
      927/12/1950Timothy
      1023/09/1941Jery