AnsweredAssumed Answered

Converting yyyymmdd date field

Question asked by VenturaDon on Jun 8, 2009
Latest reply on Jun 8, 2009 by 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

Outcomes