Convert Date Time Format

[NeohLooi]

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? 

[VJR]

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]

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

Regards,

Krešimir

[NeohLooi]

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.

[MichaelAnnis · Accepted solution]

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”. 

[NeohLooi]

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?

[VJR]

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.