4 Replies Latest reply on Dec 20, 2013 6:00 AM by John Walk

    Date out of String

    John Walk

      I have a very strange problem when trying to convert a string into a date:

      The string is in the format "20131101" (1st of November 2013), I use the following function "DATE(RIGHT([day],2)+"/"+MID([day],5,2)+"/"+LEFT([day],4))".

      This only works in a database extract in which I only have 1 or 2 different days (left hand in screenshot), but when I add this formular to the real database with 30 different days in it (right hand in screenshot), it does not work.

       

      Can it be an issue that the database with 30 days in it has 20million rows and the the extract with 2 days onl 1.3m?

       

      Thanks a lot in advance!