Help with date (identify and count the days)

Help
1

Hi, I have 2 questions. Can uipath identify date? I have a text file. Can it extract all the dates from the text file by identifying it. My date is in this format: 01 Apr 2018 to 30 Apr 2018
Into something like this
image
Secondly, Can Uipath count the days for example in 01 Apr 2018 to 30 Apr 2018 there are 30 days.

Thank you xoxo

2

@sangasangasanga uipath can count number of days between 2 dates, as per my idea it dont recognize date directly in text.

3

Please, see the following attachment.
_Test.xaml (7.5 KB)

3 Likes
4

Hi, could you explain more on how uipath does it?

5

@sangasangasanga Below one give number days, maybe it give one day less.

(newdate-olddate).Days

6

How about this?

7

@sangasangasanga uipath wont recognize date directly.

8

@Manjuts90 Oh i see, Thank you

9

@Manjuts90
(dateTwo-dateone).Days.ToString
For the code above, can’t assign it to a variable is it?
image
I tried changing variable type to string and datetime but did not work.

10

in the file i’ve attached, there were the following variables:

theDate, firstDate and secondDate as String

dateOne and dateTwo as DateTime

Make sure you didn’t modify any of them.

Also, make sure date2 is String if you’re trying to assign (dateTwo-dateOne).Days.ToString to it.

11

@Tiberiu_Niculescu In your file it works. However, when I try to add it into my workflow it keep giving error even thought variable type is string

image
image1329Ă—370 16.3 KB

12

@sangasangasanga can i know datatypes of dateTwo and dateone variables.

13

@Manjuts90

image
image1141Ă—722 24.4 KB

image
image1003Ă—724 25.3 KB

image
image1444Ă—178 11.1 KB

image
image1396Ă—151 9.44 KB

14

@sangasangasanga datatypes of dateTwo and dateone should be datetime not generic

1 Like
15

Hi, one more question.
For the line below,
01 Apr 2018 to 30 Apr 2018
Sometimes it might be
01Apr 2018 to 30 Apr 2018
or any of the spaces missing due to OCR accuracy.

The code below may not be then as the line may not be recognized as datetime. How can I solve this?
datetime.ParseExact(firstDate,“dd MMM yyyy”, CultureInfo.InvariantCulture)

16

@sangasangasanga u may need to change the date by inserting space or u have change the format of ParseExact method.

17

I tried to do this, but I am not sure what if condition I can put

I cannot do it manually as I have about 100 pdf files

18

@sangasangasanga u have to identify the those lines one or other way using uipath then only u can do anyone those 2 methods.

if ur reading data from pdf use read pdf activity it is much better OCR technique.

1 Like