Veröffentlicht Mon, 21 Mar 2022 18:30:28 GMT von 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
Veröffentlicht Mon, 21 Mar 2022 22:20:52 GMT von 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.

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.