Posted Mon, 21 Mar 2022 18:30:28 GMT by Michael Weingand Professional Services Manager
I have a customer who's dates are in the format seen below, and I need to convert them to a standard US date format in my workflow.
02212022 should be 02/21/2022.
I am using Arithmetic Expressions to grab and parse this date from the file name.

Any help would be appreciated.
Thanks
Michael
Posted Mon, 21 Mar 2022 22:20:52 GMT by Jon Weston File IT Solutions Sr Application Developer and RIM specialist
Hi Michael, if your output is a string as well then you should be able to use something like Left(GV_Input,2) + '/' + Mid(GV_Input, 2, 2) + '/' + Right(GV_Input,4) in the Assign Data->Arithmetic Expression.  I'm doing this from memory and I believe the 1st position in a string is actually position 0 as far as the Mid() function is concerned, and I've written it that way, but if I'm wrong you'll just need to adjust that.

You must be signed in to post in this forum.