Hello, How do i format string array items(all items are dates) currently in “MM/dd/yyyy” into “dd/MM/yyyy”. I need all my dates in a array even after conversion. Many thanks :slight_smile:

That looks good. I think your finalArray has the dates stored like datetimes, and when you tried to convert the format, there is one value that’s not a date, like the first value maybe. Maybe that’s why you used .Skip(1)? Anyway, you can undo the If activity, so it’s just the activity. And, in the …

Hi. Could always use a ForEach loop with an assign inside, but my approach is usually linq. For linq, you would use the .Select() Then, reformat the dates as desired. arrVar.Select(Function(d) Convert.ToDateTime(d).ToString("dd/MM/yyyy") ).ToArray For extra robustness, you might want to make su…

Hi, Could you please provide an example or elaborate more thank you

Sorry about that. I don’t have a screenshot on me right now, but you can simply use an Assign activity to assign the converted array. Assign activity: arrVar = arrVar.Select(Function(d) Convert.ToDateTime(d).ToString("dd/MM/yyyy") ).ToArray The way the .Select() works is it initializes ‘d’ by doin…

Hi, The .toArray at the last part is not showing up when i type . [image]

For my codes i read range of excel and filter a column and then output it as string. After that i split it into a array. [image]

[image] Magpie444: The .toArray at the last part is not showing up when i type Did you try typing it out anyway to see if it fixes the blue mark? If you get the blue mark, can you show what that says? Thanks.

Hi, There is no blue mark after i type it out but theres an error when i run the process [image]

Column that’s bring filtered [image]

Looks like the dates are already in “dd/MM/yyyy” format in that file. So are you only wanting to convert them if they are not in that format, because this might make it more complicated. However, what you can do is simply surround the Assign activity with an If activity. So place the Assign inside …

Hi yes the dates are in the format that i want in the excel file but when i display them it shows up as “mm/dd/yyyy” [image]

Format Dates in String Array

Help

Magpie444 (Magpie444) August 8, 2019, 5:14am 12

Hi
I did the if activity but its not working.

How to convert string array to datetime array?

Topic		Replies	Views
How to convert string array to datetime array? Help	25	9364	October 14, 2019
Question related to date type Studio	3	1061	March 11, 2022
Convert 1d array of dates to a single string, changing format Studio	2	615	September 7, 2022
How to convert date format? Studio excel , activities , studio , question , date , datetime , convert , datetime-linq , converting	19	177	January 7, 2026
Date Format conversion issue in excel Activities excel , activities , question , vba , linq-query , invoke-vba	5	692	January 6, 2024

Format Dates in String Array

Related topics