Have a date coming in as a numeric (YYYYMMDD). Need to convert it to a MM/DD/YYYY to place into metadata for a document. Can't quite seem to find the right WF tool to do the job.
Literally a string of 8 digits? I would try pattern matching in 3 sets to get the tokens.
Year - (\d{4})\d{4}
Month - \d{4}(\d{2})\d{2}
Day - \d{6}(\d{2})
You can use the Token Dialog for the token in question and check the box labeled 'Apply Formatting'. If you click the question mark it will take you to this page where you can decide how you want to format it. In your case it would be MM/dd/yyyy.
Good Afternoon Michael,
I am actually looking to do the same thing and I am hoping that you can share how you were able to make this work?
Thanks
Drew
Drew,
Guessing there may be more than one way to accomplish this. I ended up breaking the date field apart, then put it back together in the format needed (see Erik's suggestion above).
Mike
I was thinking that was probably the route I would need to take but thought I would just double check just in case you were able to work some magic another way. Thanks for the response!
Drew