Should be able to do this with the DateTimeConverter.
Set the Input format to:
%m/%d/%Y
And the output format to:
%y%j
More Date/Time Functions and explanations here if needed.
Hope that helps.
Thanks chrisatsafe. A follow up question, how can I extract a four digit year instead of two?
Ignore the follow up question. I figured it out, I use uppercase "Y" instead of lowercase "y". Thanks a lot for your help.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.