Convert Date "dd Mon yyyy"

Help
1

Hi All,

How do you convert the scraped data in the format “dd Mon yyyy” into the standard “dd/mm/yyyy”? Any help would be greatly appreciated

2

yah like this
str_datevalue = Datetime.ParseExact(strinput.ToString,“dd MMM yyyy”,system.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Cheers @Stabbathehut

1 Like
3

What if the string is in a datatable in the first column under column name Date Published

4

Fine
then use a FOR EACH ROW activity where we can pas the datatable as input
and inside the loop use a ASSIGN ACTIVITY like this
row(“Date Published”) = Datetime.ParseExact(row(“Date Published”).ToString,“dd MMM yyyy”,system.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Cheers @Stabbathehut

5

Depends what do you want to do with the date? is some calculation or just to write somewhere? If the second then:
Datetime.ParseExact(row(0).ToString,"dd MMM yyyy",system.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

6

Hi

image
image1920×1040 71.8 KB

so what I am trying to do is iterate through the date published column where it checks which values in the column equal todays date and then carry on with the process

7

yah use the expression like this in IF condition
Datetime.ParseExact(row(“Date Published”).ToString,“dd MMM yyyy”,system.Globalization.CultureInfo.InvariantCulture).Equals(Datetime.Now)

Cheers @Stabbathehut

8

It says that string was not recognized as a valid DateTime

9

Fine lets validate like how we are getting the value from excel
before this IF condition use a writeline activity and mention as row(“columnnam”).ToString
so that we can see the value in output panel based on which we can change the expression in IF condition
kindly share the screenshot of it plls

Cheers @Stabbathehut

10

image
image1920×1040 72.1 KB

image
image1920×1040 20 KB

image
image1928×1048 182 KB

11

the expression be like this in IF condition
Datetime.ParseExact(row(“Date Published”).ToString.SubStrinng(0,10),“dd/MM/yyyy”,system.Globalization.CultureInfo.InvariantCulture).Equals(Datetime.Now)

@Stabbathehut

12

So you excel already has that column as a Date and not string, you dont need to do anything to it to verify if it is the same day as today, did you even try in you IF:
DateTime.Compare(CDate(row(0)), DateTime.Today) = 0

13

Hi I tried that and it is saying conversion from string “17/01/2020” to type ‘Date’ is not valid

1 Like
14

DateTime.Compare(Datetime.ParseExact(row(0).ToString,"dd-MM- yyyy",system.Globalization.CultureInfo.InvariantCulture), DateTime.Today) = 0

15

did this expression helped us on this
@Stabbathehut

16

No errors but the if statement doesn’t work. Can you try this before suggesting as its a bit frustrating trying these ways when none of them have worked

17

string is still not recognised at datetime

18

so then you do not have this format: 17/01/2020

19

image
image1928×1048 240 KB

I am just confused with the formatting of this.

20

This is just the way excel shows you this data, does not mean it gets to your datatable like that…