6 Replies Latest reply on Jun 8, 2009 4:10 PM by VenturaDon

    Converting yyyymmdd date field

    VenturaDon

      Title

      Converting yyyymmdd date field

      Post

      As a newbie to FP, I just imported 270k records with a date field in yyyymmdd format. To convert to a mmddyyyy date field, I created a calculation field and attempted to follow a previous post:

       

      Date ( Middle ( ASCIIdate ; 5 ; 2 ) ; Middle ( ASCIIdate ; 7 ; 2 ) ; Middle ( ASCIIdate ; 1 ; 4 ) )

      Then you can even trasform that calc field into a simple date field ( the calculated date will remains intact )

       

      So in Specify Calculation I inserted:

       

      f18= Date ( Middle ( ASCIIdate ; 5 ; 2 ) ; Middle ( ASCIIdate ; 7 ; 2 ) ; Middle ( ASCIIdate ; 1 ; 4 ) )

       

      but get "The Specified field cannot be found" error msg. f18 is defined as text. 

       

      Thanks for the help!

       

      VenturaDon