3 Replies Latest reply: May 16, 2012 12:23 PM by Brian McKenna RSS

    Duplicate records being created when Month, Year etc are applied to a bad date

      Hi,

       

      I have a bad date format and am uisng the following code to extract the Date, Year, and Month.

      Thanks to those who helped with thi sbefore.

       

      However multiple records are being created when I try to extract the Date, Year and Month.

       

      Can anyone suggest why this is occuring. I've attached a simple spreadsheet and QV app. to replicate the problem.

       

       

      All help appreciated.

       

      Tony