The provided text value can't be converted into a valid datetime.

(0) Share

Report

Posted on by mfikri1609

Hi Everyone,

I have string of date that I want to convert to date time.

The string date is in "Wed Aug 31".

So, when I try to use convert text to datetime activity, it give me an error.

Anyone know how to solve this? or the format it cannot be like this.

Here the screenshot of my test activity.

Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

I dont think its possible in this format. There is one custom format option also in the text to date conversion, but in that too the format should be ddmmyyyy or similar patterns or hhmmss or similar options. So, I dont think its possible.

Only ddmmyyyy and similar patterns are only available there. If you can do some manipulations to convert that day into the above formats, then only its possible.

Was this reply helpful? Yes No
mfikri1609 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik ,
Thank you for your respond.
"Mon Sep 5 00:00:00 UTC+0800 2022" I have this format and then I use parse activity which using Regex ".+(?=\s\d{2}:)" and it give me Mon Sep 5.
I think because it do not give the year as output and as I work with the data, it give error.

Do you have any suggestion I can extract only date? because the timestamp data itself when I want to process already in that format.

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

I am not sure in PAD, how to do it. But, what you can try is using an API.
I found this code: https://stackoverflow.com/questions/11097256/how-to-convert-mon-jun-18-000000-ist-2012-to-18-06-2012
You can make an API with the above code.
You can just extract the date and send it in Post Method and then use Get method to receive the converted date.

Was this reply helpful? Yes No