Find "/" in the specified range, then type formula in the 2nd adjacent cell

[Nyx (Arnel Terblanche)]

I need to find the “/” character in the range E:E and then type a formula into column H. I have not been able to find a suitable solution for this and would appreciate any help.

[argin.lerit]

@Nyx

Check out the attached XAML file and sample XLSX. Let me know if that is what you need

DateFormats.xaml (9.7 KB)
Data.xlsx (8.7 KB)

This is the output I got where column B was supplied by the UiPath process:

Thanks!

[Nyx (Arnel Terblanche)]

The date in the “last login” column is fetched from the source and is either written as text or in the correct date format (yyyy-mm-dd HH:mm:ss).

[argin.lerit]

@Nyx

Thanks for the confirmation! Did you try the XAML I sent?

[Nyx (Arnel Terblanche)]

It has been running for the past hour and it’s still not done, there are 97 rows in the one file and over 800 in the other. Need to find another solution

[argin.lerit]

@Nyx

Try this version of the XAML please. I found an issue in the original one where the file gets saved for every row. That got fixed in this version:

DateFormats.xaml (9.7 KB)

Thanks!

[Nyx (Arnel Terblanche)]

The workflow ran much quicker now - thanks Argin

However the assign activity writes the formula as text in the adjacent row:

[argin.lerit]

@Nyx

Please check the formatting of the entire column and try to set to “General” or Custom Date that has the format you need

Alternatively, you can directly put the correctly formatted date instead of just putting a formula. Here’s an updated XAML with that being done with RegEx:
DateFormats.xaml (10.2 KB)

thanks!