dd-dd/MM/yyyy date type problem

[murat.karasoy]

hi guys, I wanna get check-in and check-out date. But check-in date only day and and could not do it. For instance 23-27/11/2020 I have to get two data 23/11/2020 and 27/11/2020 How can I do it ? Thank you.

[Gabriele_Camilli]

Hi @murat.karasoy

I would you the following steps:

1. Split on the “-”, you will have 2 strings, one with the number, one with the date

2. Assign to the first string the following: String[1] + Right(String[2], 8)

This will concat your first number to “/11/2020”

You know what happens when the dates are in two different months?

[ppr (Peter Preuss)]

@murat.karasoy
can be done with the help of Regex:

Pattern: (\d{2})-(\d{2})/(\d{2})/(\d{4})

Parts can be retrieved by refering to the different groups:

For working with Regex have a look here:

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[Cristian_Negulescu]

Hello Murat,
In this video I do a lot of stuff with String and DateTime:

UiPath Tutorial for String and DateTime (Use-cases)

0:35 Examples for Substring functions
4:10 IndexOf and LastIndexOf
5:00 SubString working together IndexOf and LastIndexOf
6:45 Split string by character
8:50 Split string by string
12:00 Lower Case and Upper Case
12:45 Trim
15:05 Compare strings in multiple ways
19:05 Resume of all the String function part
20:05 DateTime to string in multiple ways
23:00 AddDays get DayofWeek
25:40 Convert from String to DateTime
26:20 Compare DateTime

Thanks,
Cristian Negulescu