Convert datetime to text Action(Power Automate Desktop)
This Action converts a date/time into a variable of text type.
This is the counterpart to "Convert text to datetime" and is similar to Excel's TEXT function.
Contents
How to use
Drag Convert datetime to text from Text onto the Workspace.
Set parameters.
Parameters
Datetime to convert
Specify the target date/time.
Format to be use
Select whether the "datetime to convert" is the default format (Standard) or any date format (Custom).
Standard
The following table shows the choices and an example of specifying 11:30:45 on 5/10/2023.
| 設定値 | 結果の例 |
|---|---|
| Short date | 05/10/2023 |
| Long date | Wednesday, May, 10, 2023 |
| Short time | 11:30 PM |
| Long time | 11:30:45 PM |
| Full datetime(short time) | Wednesday, May, 10, 2023 11:30 PM |
| Full datetime(long time) | Wednesday, May, 10, 2023 11:30:45 PM |
| General datetime(short time) | 05/10/2023 11:30 PM |
| General datetime(long time) | 05/10/2023 11:30:45 PM |
| Sortable datetime | 2023-05-10T12:30:45 |
Custom
Specify for any date format.
Specify the date in "yyyyMMMdd" and the time in "hhmmss".
Variables produced
FormattedDateTime
The resulting text of the conversion is stored.
---