Conversion of date

(0) Share

Report

Posted on by Alphadrag

164

Hi all, i have this value in excel "3/2/2022 12:00:00 AM". How can i use PAD to convert this format to 2 March 2022?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

kinuasa 795 Most Valuable Professional on at

Like (0)

Report
Hi,
How about you try 'Run PowerShell script' action?

Regards,
kinuasa

SET StrDate TO $'''3/2/2022 12:34:56 AM''' Scripting.RunPowershellScript Script: $'''Write-Output ([DateTime]\"%StrDate%\").ToString(\"d MMMM yyyy\", [cultureinfo]\"en-US\")''' ScriptOutput=> PowershellOutput ScriptError=> ScriptError Display.ShowMessageDialog.ShowMessage Message: PowershellOutput.Trimmed Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True ButtonPressed=> ButtonPressed # [ControlRepository][PowerAutomateDesktop] { "ControlRepositorySymbols": [], "ImageRepositorySymbol": { "Name": "imgrepo", "ImportMetadata": {}, "Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}" } }

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi,
Perhaps the answer in this thread (https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Formatdatetime-in-powerautomate/td-p/1268496#:~:text=In%20Power%20Automate%20Desktop%2C%20we,%DAte_String%25%20in%20the%20email.) could help?

Was this reply helpful? Yes No
Verified answer

UK_Mike on at

Like (0)

Report

Convert Datetime to text action.
Custom output.
dd/MMMM/yyyy

Was this reply helpful? Yes No
Alphadrag 164 on at

Like (0)

Report

Hi, if i got 9:00, how can i convert it to 09:00? This is time.

9:00 is being stored as a text in excel

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Use "Convert datetime to text" and in the Custom format provide hh:mm

Was this reply helpful? Yes No