cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NeohLooi
Helper II
Helper II

Convert Date Time Format

I run a desktop flow that get date from excel file and want to input it to a date picker in google form. 
I have a hard time convert the date to the format in date picker in google form.

The date format I get from excel : 1st May 2021

The date format google form require : 1-May-2021

 

Is that anyway I can convert the date? Or is that any formula/expression can perform this conversion? 

1 ACCEPTED SOLUTION

Accepted Solutions

Look at the article posted by @VJR

 

him and I both posted different ways you can replace text to get rid of the “st, nd, rd, or th”. 

View solution in original post

6 REPLIES 6
VJR
Super User
Super User

Hi @NeohLooi 

 

Can you take a look at my similar post here.

That should be able to help you achieve what you are looking for.

Kresimir_RPA
Advocate III
Advocate III

You can use action called Convert datetime to text and then use custom format d-MMM-yyyy.

 

datePADforum.JPG

 

Regards,

Krešimir

I tried this solution, but PAD do not identify 1st May 2021 as a valid date format, the error mentioned it nots a valid date format.

Look at the article posted by @VJR

 

him and I both posted different ways you can replace text to get rid of the “st, nd, rd, or th”. 

I just found out when the month is August, due to the replace text action, it become Augu at the end. Any solution can avoid this issue?

Hi @NeohLooi

 

That's a good find.

 

st comes only for 1st, 21st, 31st.

So in the replace add 1st. But add back the 1 after replacing with blank.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,933)