Change of date format

[Robert_Wennberg]

Hello!

I am grabbing dates from a web page and store them as a variable to later put into an excel file. However, the formatting of the dates are like this “Jul 1, 2020, 8:17 PM”. Excel does not recognize this as a date, and I would like to make it so that you could compare the grabbed dates to something like “DateTime.Now.ToString(“yyyy/MM/dd”)”.

Is there any way this can be achieved or is it too difficult and complex of a task?

Best regards
Robert

[HimanshuSonawane]

@Robert_Wennberg Please find below xaml file for your requirment

Main.xaml (5.1 KB)

I have converted date which you extract from web page to “yyyy/MM/dd” format .Please check above file for the same .

If this satisfy please mark it as soln .

[Pratik_Wavhal]

Hi @Robert_Wennberg

You can do below thing :-

DateTime.ParseExact(CDate("Jul 1, 2020, 8:17 PM").ToString("MMM dd, yyyy, HH:mm tt"), "MMM dd, yyyy, HH:mm tt", System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy/MM/dd”)

Workflow :-
MainPratik.xaml (6.4 KB)

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[ppr (Peter Preuss)]

@Robert_Wennberg
have a look here on a direct (string - datetime - string) conversion

[Robert_Wennberg]

@Pratik_Wavhal

Sorry for the extremely late reply!

This is the solution I was looking for. In my case I just changed the actual date with a variable and it works smoothly.

Thank you so much for your help!