投稿済み Mon, 21 Mar 2022 18:30:28 GMT 、投稿者 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
投稿済み Mon, 21 Mar 2022 22:20:52 GMT 、投稿者 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.

フォーラムに投稿するためにはログインが必要です。